Very nice article, in particular putting the power consumption into perspective. One aspect to consider is the frequency spectrum of power consumption and generation, in particular daily and annual components. This allows you to calculate the order of magnitude of energy that needs to be stored.

If you are interested, I tried to do a simple simulation for the UK, projected for 2030: https://peter-wurmsdobler.medium.com/could-wind-farms-power-every-uk-home-by-2030-power-analysis-e920ff5b5ee2