That's true to a degree, but there's always the not-in-my-back-yard condition.
I got to see this first hand during the Barnette Shale gas drilling boom in the mid-2000s. As Texas, particularly the DFW area was very pro-oil&gas, many people were very much in favor of fracking and the possibilities it opened up.
Many of those people stopped being in favor once actual wells appeared in their neighborhoods. At one point I could see five different wells from the second floor of my suburban home. Their noise was audible all the time, and our roads became clogged with heavy trucks delivering liquids and materials necessary for the fracking process. Oh, our roads got destroyed rapidly from those trucks as well.
The few landowners who got lucrative mineral lease deals were very happy, but "the people" living all around were definitely not happy. So a small few individuals profited well, a few oil and gas companies profited very well, and the general population suffered.
That was even before the earthquakes started.
Keep in mind also that "the people" are generally speaking rather like sheep -- not stupid necessarily, but given to following the herd. "Everybody knows" that Texas is an oil state, so it's only natural that you will be in favor of the industry your state is famous for. To go against that means you no longer fit with your neighbors, colleagues, church members, sometimes even your family (if you're from Texas you probably have a cousin who works in the industry) etc.
However, after negative outcomes appear too often or too clearly, the concept of "the people" fractures. I can't speak for the SF folks, but I would bet that there are quite some strong differences of opinion amongst them, just as there are people living in nature who are very opposed to development around them.