Exactly what I am saying.
Say you are digging into a pile or a stump...and with no
ballast the back wheels keep coming off the ground right.....
Now let's say the tractor weighs 2500#....and is able to expert (lift) 500# before the back wheels hike into the air. That would make 3000# all be on the front axle right......
Now let's add 500# of ballast. And that is enough to make the loader lift 800# before the rears lid in the air now. (Insufficient ballast). But now the 2500# tractor, 500# ballast, and now 800# load is all on the front axle. Total of 3800#.
So let's increase ballast to 1000#. That can now make our loader lift 1100#. AND the rears stay planted but barely....and only retain 500#.
So the 2500# tractor, 1000# ballast, 1100# load is now the total weight of the machine at 4600#.....but still 4100# on the front
Adding ballast/counterweight only adds to the "potential" loading of the front axle. But only up to the point of ENOUGH weight on the back to actually start unloading the front axle.
But this varies by tractor and loader lift capacities. With "just" enough ballast to max out the loaders lift capacity yet have next to zero weight on the rears is the worst case scenario. Because from that point onward any addition rear ballast will shift the fulcrum back to the rear axle and start unloading the front axle. But until that happens.....you are only adding to the potential front axle load