The Manhattan Contrarian looks at a Royal Society report about green energy and storage
https://www.manhattancontrarian.com/blog/2023-9-28-a-semi-competent-report-on-energy-storage-from-britains-royal-society
Tens of terawatt hours of storage is needed - "far more than could conceivably be provided by conventional batteries."

A chart of generation is also shown - a 23 year period of relatively good production with a HUGE shortfall that followed as well.

Other good stuff in this story plus a link to the original report  near the top.