Switching to gas is just trading one version of disaster for another. Instead of your world being razed by Godzilla you spend lots of money so it gets razed by Hedorah instead.
Here's one recent take on the issue: https://reneweconomy.com.au/a-100-renewable-grid-isnt-just-f...
Note that last bit: as we shift to a transport fleet consisting of more and more EVs, the possibility of using storage to balance out demand vs supply becomes more likely, without huge investment in utility scale static batteries.
Still not ideal, of course. But it absolutely has its place as a transition fuel as we work to decarbonize our energy production.
Methane is not a transition fuel, it is simply a smoke and mirrors truck replacing some of the CO2 emissions of coal with methane emissions from well to furnace. Methane is far worse than carbon dioxide, we should not be following plans to increase methane emissions for a token reduction of CO2 emissions.