I wish there was a place where smart people could gather to solve problems like this. You know, maybe invent a device that takes the electricity when it is cheap (when the invisible hand of the free market wants it) and gives it back to the grid when the price has risen because there is no longer that much sunshine.
There have been a zillion science/tech articles over the last 10 years, about possible ways to store power at scale. There is not yet a silver bullet.
Well the problem isn’t a werewolf, so all the regular bullet solutions, when used together, are enough to deal with it.