But the two chief uses will be in industrial processes that use hydrogen directly, in chemical processes that use hydrocarbons directly, and in energy storage applications where you need to store large quantities of energy for weeks or months or years.
One of those niches: boats. Specifically: user-owned recreational ones.
Not because it's hard to build electric propulsion systems for boats. There already exist many types of motors, batteries & control systems to choose from. Not because battery weight / size is a problem (it isn't). Not because of safety issues (gas/diesel have their own).
But because it requires a big upfront investment. Converting to electrical propulsion is (for most boats) expensive. For someone who already owns a gas/diesel powered boat, but not the $$ to convert into all-electric, that's a big hurdle.
Of course new boats will replace old ones over time. But average boat lasts much longer (read: takes much longer to replace) than eg. cars. Average car is what, 6..8y old? Average boat more like 20y+. Electric conversion that's both easy and cheap, is not a thing (yet?).
Professional owners like ferries, commercial shipping or boat rental, will deal with this. Private owners of recreational boats, not so quick.
That means: there will be gas/diesel powered boats around for many years. Having 'green' fuel for those available everywhere, would be quite a boon.
Not saying people should switch to resistive heaters since they significantly less efficient than heat pumps but simply that resistive electric heating would be cheaper than hydrogen (If that hydrogen is produced using electrolysis).
IF the capital cost of electrolysis isn't too bad - and this paper suggests that it can be done more cheaply than the current use of platinum - then it's economical to run them with zero or negative cost electricity produced by renewables overbuild, then keep the hydrogen in tanks (another if) or convert it to actual natural gas via the sabatier reaction and keep that. That may be cheaper than building really huge battery farms for long-duration electric storage.
I am not saying making hydrogen can't be economical utilizing cheap off peak rates. I just don't see it as economical for home heating or typical consumer transportation since there are alternatives that utilize electricity directly.
Instead there is a lot more interest in using green hydrogen for industrial purposes or as a key building block for cleaner fuels like methanol. Currently green hydrogen is expensive to make and sucks to transport. But it will likely get a lot cheaper to produce in the next 10 years and you can convert it into fuels that are easier to transport.
There is recent episode of Volts that interviews a startup trying to do this: https://www.volts.wtf/p/making-shipping-fuel-with-off-grid#d...