Majorities of young adults and Democrats say climate change will make their local area a worse place to live