Wouldn't you spend almost same amount of energy to split water compared to heat produced by burning hydrogen?

But you could technically build huge solar panel areas in deserts and bring that hydrogen to populated areas. Or you could use excess energy from renewables to produce hydrogen, storing at least some of the excess energy for times where renewables produce less.