It's simpler than that. Left leaning folks exist within the contradiction just fine via harm reduction.

Right wing people just will never admit they are wrong about anything. That's really it. They will simply invent an entirely different reality before they will knock over a single card in their card house.

IMO you're much too charitable. I think these are the reasons (at least for American conservatives), roughly in order of what I consider to be the most to least sympathetic:

• A fondness and nostalgia for fossil power. To be clear I think if this is the reason you're supporting fossil fuel use when lives are on the line you're crazy, especially when museums and motorsport categories for older engine technologies can (and already do) exist, but I can at least understand it.
• Anxiety about change. While there are lots of reasons to think that renewables will put us in a better position than fossil fuels (they're cheaper, can be less centralized, and better insulated against geopolitical instability) a lot of people are very anxious about things like EV range and grid instability. If they're a "low information voter" or have been fed a steady diet of oil industry propaganda then they probably have a very exaggerated view of these issues and a very poor understanding of how the world works.
• The entire idea of anthropogenic climate change and things like a circular economy directly contradicts the Christian worldview they're operating under. For one they don't believe in climate change for the same reason they don't believe in herd immunity from vaccines or systemic racism. Cumulative effects, dynamic systems, and tipping points aren't part of how they think the world works. Secondly, they view the world as something their god gave to humanity to conquer, dominate, and exploit. Telling them that they can't suck the world dry and throw away the husk come judgment day is tantamount to telling them their religion is fake.
• For a portion of the population the above three attitudes have metastasized into conspiracy theories and fascist ideologies. Things like a belief that "15 minute cities" means they will be put into open air prisons, or that wanting to reduce resource consumption means that they will be subjected to population control so that black people can replace white people. I don't feel like writing a giant comment examining the core of the reactionary mind, but suffice it to say that things like language and truth are very fluid for them. If something makes them feel bad then it must be bad, literally and physically. The conspiracy theories are created to justify the feelings.
• In addition to the above plenty of people want to hurt others. The fact that large powerful vehicles kill people, the fact that they're loud, inconvenient for others, and spew black smoke, makes them more appealing. The fact that oil use creates wars that kill children is a bonus. All of this is tough and manly. It makes them feel good.

Also, for many, their livelihood and how they provide for their family is directly tied to fossil fuels and the price of fossil fuels.

Do not, my friends, become addicted to oil. It will take hold of you, and you will resent its absence!