The reality is always just out of reach, like nuclear fusion.
One more huge issue with hydrogen fuel - hydrogen is the lightest element in the universe, with just one proton.
That means that hydrogen gas must be massively compressed in pipelines and storage tanks to equal the same number of BTUs in natural gas, which is moved and stored at much lower compression.
Massive compression equals more energy consumption, and, it dramatically increases the risk for explosions and fire.
For pipelines not as much as you think methane has 1000 but per cubic foot at STP hydrogen is 325 at the same STP a 500 psi methane pipeline would need to be at just under 3x the pressure for equal energy transport. Hydrogen has a lower energy of compression than methane so it’s not three times as much energy to compress it. The’re are hundreds of miles of hydrogen pipelines all over the Gulf Coast region for the oil refineries the problems of hydrogen pipelines were solved decades ago. You can see one along IH10 between Beaumont and port A Texas if one knows where to look.