It's a bit more complicated than that, actually I produce (far) more energy than I consume from solar (200m² home, 5kWp domestic plant) BUT I produce it just during sunny days witch are many here (south France) but not all and in all case not in the evening/night.
Having a reasonably big water heater I heat water from electricity [1] during the day and get it hot enough in the evening and next morning without extra energy needs, so actually the time-limited daily production for hot water can be shifted enough to cover 24h, actually if I do not use that much or install something bigger even around two days.
Something similar is valid for some other energy needs, for instance cooking, washing cloves, dishes when the Sun shine means full self-consumption witch does not cover the total, but heavily reduce grid usage. In the summer, at least here, I run air con almost full-power without consumption from the grid, in the evening and night temperature drop far more than enough to not need extra energy. Being on mounting in absence of sunlight I do not normally needs air con also during the day.
The real issue is another: grid stability. While I can easily produce enough energy in most days of the year when a load start solar inverter react slowly, when a load drop there is an excess of energy for a little time. ALL kind of generators do like static or slowly changing loads and do NOT like spikes. That's the real issue. In a large enough, but not too large, grid loads tend to remain stable enough, changes are more like "background noise changes". On a microgrid things are far different. until we found a way to waste excess energy, for instance to heat water, with something that can be feed with any amount of power p.v. and eolic generate stability issues and alone can't work enough in a microgrid. Smart grid AND devices that are able to slowly load and unload would be of help, but we do not have many.
In infrastructure cost IMVHO if/when we can solve the stability/load issue costs are still lower because any issue is still local and can easily have local backups. Cutting the need of quick restore cut the costs enormously enough to compensate.
[1] yes, is LESS efficient than classic solar BUT I still need electricity for other things and since production is enough during the day it's a nonsense for my needs have two kind of plant just for hot water.