First order approximation, overbuilding solar and wind is for the purpose of filling in some of those intermittency periods. I.e. today in Portland, OR it is an unsurprisingly gray day (we get those this time of the year). But it's not really bad, so today might be a 20 kwh day from our panel system rather than the 60 kwh we get on a good summer day. Assuming that satisfied our daily needs (60 kwh) then a 3x system would have us covered today.
So overbuilding provides enough power for the always-on uses over more hours and days of the year. Of course that hypothetical 3x system would be generating 2x of need over some of the summer days, and nowhere near enough over some of the winter days (really bad days can stay under 1 kwh from our system).
One of the uses that's being hypothesized for that surplus energy is the one you mention - hydrolyzers to make hydrogen. One purpose for that hydrogen is energy storage. I tend to think that hydrogen storage for energy shifting is a bad idea, though only because hydrogen is such a difficult thing to store. Bind on a carbon molecule and you can get methane (CH4) or a nitrogen molecule (NH3) for ammonia. I know that we know how to use methane to make electricity, and if the manufacture is strictly renewable energy based, then the carbon cycle is net-zero. I don't know if ammonia has energy storage properties - it clearly has industrial applications - but its another option for something that can be made from air and excess energy. (I also don't know the degree to which those chemical processes can be shut down and restarted - so very, very much that I don't know).
An idea from Australia that applies anywhere - bring the big renewable energy to new mining projects. These tend to be far away from the electrical grid, and are energy intensive. So they truck in diesel to run local generators. Replace that with a solar and wind farm with battery and diesel generator backup and the mine can cut its carbon intensity immensely.
Even better - build a LOT more energy and you can do the ore processing much more locally and ship raw iron (or whatever) instead of iron ore (rock with a relatively high fraction of iron). More local jobs, less transport, and less transport energy.
An idea that occurred to me - use the excess energy to run desalination plants. The obvious use is municipal water sources for cities close to coasts. But what about making enough to pipe water inland for ag irrigation? Or pipe it further inland to dump into rivers to keep them flowing year round; might need to chill it to make sure you've got the right water temp
. Even the idea of making fresh water, pumping it far inland, chilling it to the right mountain melt temp, and pouring it out to make or sustain a river - totally ridiculous. And yet maybe not so ridiculous for the US West.
So very, very much that can be done with surplus energy.
And I think this is really the core idea. Our whole energy system in the history of the human race is built around the idea of producing the energy you need, and not more. Excess energy is wasted energy, and there are raw materials that need to be mined or created in some fashion, so excess energy is an important wasted resource. With solar or wind energy though (or at least solar), the consequence of overproduction is that some portion of the planet is shaded that didn't need to be in that moment.
I think that this will be the hardest mental model for humanity to change - excess / overproduced energy is a good thing in the evolving energy system. The clever scientists, engineers, and business people that will figure out how to make use of it - they'll come along whether we can imagine it today or not.
Netflix wasn't imagined by anybody in the '90s. And now a household that can't get arbitrarily large amounts of streaming video delivered for a flat rate monthly access fee is at an important disadvantage to the rest of society.