This gives you a rough idea of the total bridging capacity for the case of "no sun, no wind" situations.
That said, I must admit I am a bit afraid of the huge batteries, at least if they are going to be located close to human dwellings. The videos of fires of vehicle batteries that I have seen so far were pretty bad, and here we are talking about orders of magnitude bigger energy store.
Out of all the users of energy that you listed perhaps the industrial sector is worth mentioning, otherwise street lights are essentially in the same magnitude of lights-per-capita so that can be a constant tacked onto the # of homes metric. Not to mention the fact that quite a substantial portion of them now use LEDs. The others are a magnitude less significant in comparison to homes, whether those homes are rural through urban.
In that sense, it makes totally sense. If you are Greenpeace (for instance) and argue that all nuclear plants have to be close (for reason X) you need to translate that production with something else. And that amount can't be reasonably replaced by solar + wind + batteries.
Some people, including many "greens", do want to replace nuclear with renewables + storage (at best, the other day Greenpeace Belgium said that "natural gas is a necessary evil for transitioning away from nuclear and to renewables" (as in, we should retire nuclear ASAP to move to natural gas until renewables are ready), so it does make sense.
The rest of the world will set up their own primary energy storage providers as well. Imagine each continent had a primary battery hub. Secondary storage can be in the countries that have the space or can afford the additional infrastructure.
Also, remember this is how a lot of the world works now with existing energy infrastructure.
Don't try to make the simple complex. Solar "tunnels" where existing roads are. Vertical building for batteries in space restricted areas.
Not every locality will have the place, budget, geography to enable that.
Furthermore, "a lot of batteries". Isn't there a shortage of battery production capacity currently? Isn't there a massive shift to battery electric vehicles which will need multiple times the battery production capacity available today?
Wasting enormous amounts of space, money and production capacity to be able to offset a couple of hours of no wind/sun seems wasteful and risky.
and if cost is the main thing holding back renewables, nuclear will never win, because it's an order of magnitude more costly. It takes a LONG time for something that costs a billion dollars to break even versus renewables that cost $100M.