"I know some people who are adamantly against solar and wind ..."

Ignore them because it doesn't matter.

Physics causes finance, which causes politics ... and their politics will immediately change when the finance crosses whatever threshold they happen to be anchored to.

That's different for different people and different situations but you can be sure it will happen. Those people will not pay markedly higher electrical bills or have a (relative) doubling of their cars TCO for their politics.

Just be patient.