This is not necessarily a contradiction. The vast majority of people support “doing something to save the planet,” and a vast majority also support not being personally affected by that something. It leads to cognitive dissonance which shows up in surveys like these.