This first thing we need to do is align the costs and incentives. What I mean by that is simply allow the market, or government, to dictate the real cost of providing electricity at night. If there are no solar panels (nighttime), and whatever grid-scale batteries are available cost 1$/kwh then so be it, charge that amount to the consumer. People will learn to forego "bathing" in electricity at night endlessly. For decades we've been spoiled with ridiculous "energy on a tap" that just gives us oodles at the flick of a switch, and we just need to take that away.
As a side-effect of this whole "switching off the endless tap", micro-grids are the future. Small communities with mini-grid-scale batteries and sharing of electricity will take over this stupid "national synchronized grid" idea that has gimped our ability to be agile wrt local energy generation.