Heating and lamp gas composed of of hydrogen and carbon monoxide (!) were once delivered throughout cities through cast-iron plumbing. That was displaced by "natural gas" as increasing numbers of people were found to have been asphyxiated after a lamp flame in their house died, typically from a pressure fluctuation.

Natural gas then had to have mercaptan odorants added after leaking gas accumulated undetected and exploded. Then, valves that would only stay open when hot came into regular use, for pilot lights. Now pilot lights are gone, replaced by spark generators. Hydrogen will displace natural gas in industrial settings, but synthetic methane or propane will probably be needed for domestic use.

I'll add that the alternative proposal, excess renewables with curtailment, has 0% efficiency on the curtailed power. Using that power for anything at all, including making hydrogen, is more efficient that just dropping it on the ground.

But hydrogen is very far from the only storage choice, it is just one that is attractive for numerous ancillary reasons: we need to make the hydrogen regardless, so might as well store it too.