FWIW, the latest analysis I've seen seems to suggest that biomethane is probably the way to go for last-resort long term backup. Hydrogen is just too fickle.
What does it mean for a gas to be 'fickle'? Hydrogen gets stored long term all the time. It's made in refineries and used in chemical plants all over the world every day. It's expensive to store, but it's certainly doable with the right metallurgy. If your goal is reducing carbon emission as much as possible, it's way better than methane, regardless of source.
biomethane aka methane from rotting plants? extremely inefficient and requires intensive agriculture