https://www.cnbc.com/2018/07/06/the-us-natural-gas-industry-...
new studies suggest the leak rate is around 2.3%, which is about twice as high as previously predicted - and at 3% you have offset all the benefits compared to coal generation. Again, obviously that's still better in terms of particulate emissions/acid rain, but you wouldn't be doing any less global warming. So it is still significantly bad in terms of greenhouse effect, not nearly the panacea the fossil-fuel industry would like to present it as.
(and conversely - the fact that it's such a distributed problem makes it difficult/expensive to clean up. you can capture CO2 and particulates from a point source - it's expensive and it sucks but you can do it. But you can't stop 2 million miles of pipes from leaking a little bit at every fitting.)
the only saving grace is that methane does oxidize relatively quickly, on the order of tens of years, whereas CO2 is pretty much there forever. but if we're still pumping out more natural gas into the atmosphere 10 years later, that's not really the fix people think it is. Again, it's 100x more potent over a 100 year lifespan than CO2, the "long term" picture isn't all that rosy either.
Unfortunately, in many places you can't produce oil without producing gas, and with so much gas right now, there's not a lot of financial incentive to capture it all. If we reduce the need for oil, we'll reduce gas leak emissions as well.
https://response.restoration.noaa.gov/oil-and-chemical-spill...
Why would it be different for other things created by the same processes? And do the pipes let less leak out than if we just left it in the ground?
Oil and gas seeps notwithstanding, the vast majority of reservoirs are stable and likely to remain so over human timescales unless we stick wells into them and start piping fluids around on the surface.