Green Hydrogen is going to be big. You are correct that if you are burning it then you have taken a wrong turn, or at least haven't got to the final destination.

Mostly it will be a sink of energy and a chemical feedstock. That is still massive, size of the oil industry scale big.