The answer to this is local energy storage. It could be at the home level, but doing it by neighborhood/industrial block would be better

Then, you lessen the strain on the grid at large, and you also capitalize on the periods of low demand. This means less spot energy production and built in storage, making it easier to make the most of renewables while minimizing the need to fire up a natural gas plant to make up the difference