Suppose I have a 100MW gas turbine. And suppose there's 1MW of solar installed in my generation network. I don't really care if I sell 80MW at noon and 90MW around dinner time and 50MW through the night, or if instead it's 79MW at noon and 91MW at dinner and 51MW at night. The gas costs about the same irrespective of when I burn it so a bit of a fuel shift doesn't really matter.
But take that 1MW and turn it into 20MW and suddenly we go from 80MW at noon to 60MW at noon, 90MW at dinner to 110MW at dinner and uh oh. You see the problem? Whatever losses I endured at noon I don't get to make up for at dinner because my plant only goes up to 100MW and now we're not just shifting when we burn how much fuel, we're literally having to shift the power generation to a different plant.
Is this example precisely accurate? Absolutely not. But it helps you get a feel for the problem of net metering at scale. The grid can act as a battery for a few % of total generation, but by the time you hit some number, maybe 20% maybe 40% net metering turns from a cool math trick to a real cost on the grid.