From what I've read, "green" hydrogen made from electrolysis with energy from non-carbon-emitting sources extremely energy intensive, as is compressing it for transport. Transport is also expensive. To my knowledge, there aren't any pipelines in Western Canada that could transport it, so I guess it's trucks and train cars. But maybe there's potential there because hydrogen wouldn't need to be the backbone of the grid, it would just need to pick up the (substantial?) slack when renewables weren't producing.
Green hydrogen certainly is more expensive than hydrogen derived from fossil fuels, but if we are imagining a 100% RE grid, that hydrogen isn't available. It does make sense to burn natural gas directly instead of burning green hydrogen as long as the CO2 charge isn't high enough to rule out use of natural gas. This is why we're not yet seeing a large green hydrogen role out in Europe.
The interesting question is whether fossil hydrogen with CO2 sequestration is acceptable. It may be preferable to green hydrogen, depending on things like methane leakage.
Another possible alternative would be artificial geothermal, with very high temperature rock at fairly shallow depth. Obviously that's not transportable.