The idea is to have the wind to hydrogen far offshore where piping the hydrogen to the beach is cheaper than running a power cable. Therefore it would not be possible to use this power for anything else.
The project is aimed at changing our hearing from gas to hydrogen, which only works if the whole gas network is converted within an area.
Whilst this could allow rail to tap off some hydrogen for use by rail I suspect that by the early 2030's that there'll have been a significant shift away from diesel use on the railways, with a fair amount of what's left being used being used by bimodal trains, which would be costly to convert/replace.
Whilst projects like the breeze would provide some rail vehicles, there's are from circa 1990 and so would be around 40 years old by the time the hydrogen is likely to bring produced in large quantities.
I also suspect that with solar hot water panels and/or heat source pumps being able to warm water before electric heaters taking it up to temperature that there's likely to be a fair number of houses which would have shifted away from gas. That's likely to make running the network more costly than it currently is, which would accelerate the switch to electric faster as gas prices rise.
That's before you consider the extra costs with upgrading the network (so as to bring in redundancy to ensure supply is able to meet the demands if there's no wind or maintenance is being undertaken).
That's not to say that it won't happen, but I suspect that by the time we get there then the low cost of renewable energy would have (in comparison) closed the gap between gas and electric heating, especially if there's carbon emission taxes, making electric the go to power source.
Especially with the potential for large upfront costs for the conversion of your gas devices, which could be used for solar panels to provide you with free energy.