Worth pointing out that the energy may matter more on a per mass basis than strictly per volume in some applications. By looking at MJ/kg, Hydrogen even beats out gasoline[1] although that's not the case for per unit volume[2]
Special storage requirements are certainly something to considering especially with high pressures typically involved for gas storage or cryogenic temperatures for liquid. Although it's not as though other fuels have no special storage requirements - it's just that we're used to their complexities
There a plenty of uses of hydrogen, and they won't stop with electrification. But we probably won't be using them as fuel any time soon (except where its energy density is important enough to override price, flexibility and some safety concerns).
IMHO synthetic methane or synthetic liquid fuel based od captured CO2 is a better option.