Hydrogen obtained by electrolysis of water isn't particularly efficient,
Hydrogen production has moved on considerably. Granted, it still requires energy but that could be provided by green/nuclear electricity, thus not contributing additional CO2.
Also the newer methods 'crack' higher end fossil fuels, which is a win-win, oil industry keeps producing, raw materials for plastics/petro-chemical industry readily available and CO2 reduced dramatically.