Now perfect balance between the centrifugal force of orbital rotation
and sun's gravity is impossible so the earth's orbit should either be
slowly decaying inwards or expanding outwards due to difference in
magnitude of those opposing forces.
This assumption is incorrect. We could make the same argument about a weight suspended from a spring. Since the force upward from the spring and the gravitational pull on the weight can't be identical, the object must get closer or further from the earth over time.
But this isn't true because the system is in dynamic equilibrium. If the system is out of balance, the weight moves, and that changes the forces on it. The result of the changes is to push it back to the median position. The same thing happens to two objects in orbit about each other.
If an object is moving in such a path that the gravity is greater than the force necessary to maintain a circular orbit, then it will be pulled closer. But this approach increases the speed of the object so much that it will shoot back out to the original location.
Now there are many things that will be able to change the orbit over a long period of time (interactions with other bodies, changes in the mass of the objects, frictional/tidal energy loss, etc.) But without them, the energy in the orbit, and therefore the size of the orbit is stable over time.
Any long-term changes in the earth's orbit is not due to a temporary imbalance in the speed of the planet vs gravitational force, but because of these interplanetary interactions and changes in the solar mass.