A possible future for it might be for large planes, boats, etc. that would really need the higher energy density of hydrogen vs batteries. The inefficiency is of course not going to be great, but it means those could possibly use renewable sources (depending on hydrogen production). Or maybe some major battery advancements come before that and make energy density less of an issue ¯\_(ツ)_/¯
IMHO synthetic methane or synthetic liquid fuel based od captured CO2 is a better option.
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
[1] 120 MJ/kg for hydrogen versus 44 MJ/kg for gasoline https://www.energy.gov/eere/fuelcells/hydrogen-storage
[2] 8 MJ/L for hydrogen vs 32 MJ/L for gasoline
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).