Fracking also significantly reduced coal and oil usage in the US (and probably elsewhere).

This had dramatic effects on air quality, and some good effects on CO2 emission.

The article also mentions that most methane leaks are from a small number of operations. So my takeaway is that rather than discourage fracking, encourage it, and also require those operations to fix their equipment.

Then you get the best of both worlds.

(And before you say: No burning any fuels at all, only renawables, remember that the perfect is the enemy of the good. It's still valuable to make things better even if you can't make them perfect.)