back in the 20s one scientist suggested building 1000s of windturbines
with electrolyzers to convert water in to hydrogen and oxygen.
so the idea isnt new. Electrolysis is probably not the best use of the energy as it is only 35%? effiecient.
WHich is why I think there may be other options to store the energy (eg. flywheel, compressed air, pumping water uphill, batteries etc.

One interesting project is the superconducting pipes which would allow use superconducting wires which would be encased in pipes containing super cooled hydrogen gas. This would allow for long distance transmission with low power loss to resistance as well as provide a storage medium for hydrogen. This kind of helps solve the hydrogen economy infrastructure problem. (Ie. the chicken or the egg of a network of hydrogen gas stations or hydrogen fuel cell ir ICE cars that run on hydrogen)

So theoretically any excess energy generated by wind turbine, solar,
tidal etc. can be converted to hydrogen with electrolysis and pumped into such a grid for later use.
They are already planning to build a test pipe.

OBviously there will be concerns about the dangers of failure of such a system - but there is a quote from an 1880 Congressional report on the invention of gasoline that puts things into perspective- it states that it would be very dangerous substance, would require all sorts of safety regulations for containment, and the subsequent move from a horse based economy would destroy Americas agriculture.