story
"To determine the potential impact of fracking in the U.K., a group of Manchester scientists ranked it and other energy sources, such as coal, wind, and solar, after considering environmental, economic, and social sustainability. Of the nine energy sources examined, the scientists found that fracking ranked seventh in sustainability.
To make fracking as sustainable as energy sources higher up on the list, such as wind and solar, there would need to be a staggering 329-fold reduction in environmental impact, according to the researchers."[5]
[1] https://www.barrons.com/articles/why-are-natural-gas-prices-...
[2] https://sports.yahoo.com/sand-fracking-now-3-times-114500960...
[3] https://cen.acs.org/environment/water/Wastewater-fracking-Gr...
[4] https://www.nationalgeographic.com/environment/article/frack...
[5] https://futurism.com/fracking-among-most-harmful-forms-energ...
The point you bring up about methane leaks is salient though, if you can't do it without leaking too much methane, it doesn't make sense. However, I don't think that's impossible. Taxing methane leakage and monitoring it from satellites, as one idea of how to do that, seems quite possible.
Obviously it's also good to mitigate damage to the environment via waste products, etc, but that also seems to be possible with the right regulation and enforcement.