Nothing will stop the fraking. It's simply too profitable for Congress to do something about it (one of the few bright areas in a dismal economy), and the courts have gutted the environmental laws too much for the courts to do anything about it. It's an intrinsically attractive business: the product is something (energy) that's extremely valuable and has exploding demand, and many of the inherent costs of creating that product can be foisted onto people in the surrounding community that have little recourse, legal or otherwise, to do anything about it.

Fracking will end when the oil/gas is gone. In its wake it will leave behind the mess the energy and chemical industries have left all over the country: polluted, barely usable land in economically devastated regions (which is what happens after the oil is gone and the companies leave) that must be cleaned up at enormous public expense: http://www.epa.gov/superfund.[1]

Every story is some form of the same thing (plug: http://cleanupdepue.org). Company moves into little town. Residents rejoice in the new jobs. Company leaves when the land is polluted and used up. Property values plummet, and the town is left with no jobs and no ability to sell their houses and move out. The western midwest is in the first part of that story right now, hopefully they'll be smart enough and not have to see what the second part looks like 30-50 years from now.

[1] Incidentally, I think one of the great weaknesses of our country is that Congress sits in D.C., a city that is insulated from pretty much every substantial problem present in the rest of the country. In this particular context, it's a city that has never seen much industrialization and which has historically been surrounded by low-intensity agriculture in every direction (now: vast swaths of suburbia). I think we'd see a different attention to environmental issues if we relocated Congress to say the industrial New Jersey/Delaware/Pennsylvania coast...