The Sierra club is more of an outdoorsman club than an environmental club. The interests overlap sometimes, but often they do not and you end up with situations like this. They want to preserve nature, not the environment. And no, this doesn't cause cognitive dissonance in them somehow.
Maybe 100 years ago it was as benign as you suggest, but it's since been hijacked by other interests, including a eugenicist and a leader who was kicked out of Greenpeace for being too radical.
The Sierra Club is chapter-based, so it doesn't matter who its leaders are - they don't pay attention to them anyway.
The SF Sierra Club is just a NIMBY front though: https://web.archive.org/web/20170620220237/http://thebaycity...
I began my career in solar system SCADA systems. My company wanted to build a solar plant in CA, it was picketed and sued by the Sierra Club. Yes, an environmental club suing to stop a solar power plant.