As someone else posted, Hydrogen has good things about it and technical hurdles. One of the biggest problems is that hydrogen is usually created by electrolysis, and that uses a lot of energy (often generated by fossil fuel sources) or they fracture natural gas. In theory it can be created biologically by genetically modified algae, but that is still a lab thing, not been done to scale (nice part? That algae can be grown in waste, that cleans the waste up and produces h2).
Storage is a problem, usually it is done under pressure, like LNG. It also can be stored as a hydride, where the hydrogen is stored bonded to a metal, and it is release by an electric current (that once it heats up, happens on its own). Another problem with hydrogen, is distribution. You could in theory use existing pipelines (same for delivering it to the house), but as someone else pointed out, hydrogen is a small molecule, you would need to redo pipelines that were designed for nat gas.
It also has less btu content than hydrocarbons like gasoline or nat gas. Not applicable to a fuel cell, but in an engine it is, would need to fuel up more
It does burn clear, but that is pretty easy to fix, you can put otherwise innocuous agent in it that would cause it to burn with color (kind of like the smell they add to natural gas, so if there is a leak you smell it).
Hydrogen has a plus, can be used as a fuel cell or burned in existing cars (if you can figure out how to store the hydrogen&get it to the engine, it is pretty simple to use it in a conventional gasoline engine, most of it is programming the ECU parameters for hydrogen, not gasoline) .
The big one is that it is carbon free, as long as the production doesn't use things that generate CO2. It burns cleanly, if it burns properly it produces heat energy and water.
With hydrogen burning, everyone has seen the pictures of the hindenberg and there is immediate "that is what my car would do!". The Hindenberg burned that badly, not because of the hydrogen, but because the fabric was doped with butylene dope (the crap if you made model planes as a kid you put on the tissue paper), that is incredibly flammable. The hydrogen burned, don't get me wrong, but it didn't explode. Gasoline vapor is a lot more explosive than hydrogen gas. If hydrogen escaped it would burn more like natural gas. Even see a car on fire blow up? I have , and it isn't a small thing..nor for that matter are the lithium battery packs in EVs we currently use. Pressurized hydrogen can blow up pretty spectacularly, but with a well designed tank that likely would not happen much if at all.
My take is that hydrogen hold promise as part of a new era, but it really isn't there yet. My guess will be biodiesel (same thing that airlines are trying with Jet fuel replacement) will be the transition, even the oil companies are ramping up production. It has the advantage of being carbon neutral, as the CO2 released is not from Carbon sources laid down 160 million years ago, it is cycling CO2 taken out of the air as part of the growing cycle.