“hydrogen, a clean fuel that produces no emissions at the point of use”, but is insanely expensive and dangerous to transport and store due the extreme difficulty in preventing leaks of the universe’s smallest atom, and the extreme combustible and explosive nature of hydrogen [see Hindenburg disaster] ...
I agree 100%. Years ago I looked into the possibility of having an electrolyzer produce hydrogen into a tank buried in the ground outside, then when needed use the hydrogen gas for a fuel cell to make electricity. In that case there'd be no transportation danger -- production, storage, and consumption would all be local. And I could use the excess solar power my system generates on sunny days that my home battery stack was charged -- might as well put that excess energy into creating hydrogen for long term energy storage. Sounded good in theory.
But the cost was extremely high, as you said. As well as inefficient. It'd take a lot of incoming solar power to produce only a little hydrogen gas from the electrolyzer and get a little power back from the fuel cell in return. (A strongly negative ROI.)
It was more efficient to find other things to do with the excess solar power. For example, one thing I do is make sure the EV is charged to at least 50% for the next day's local driving even if power isn't free (rainy days). But on excess solar days charge the EV to the top (80%) to not have to charge it if the next few days are rainy days. No change in driving habits, just changes on when I "top it off".