As Americans have increasingly experienced extreme weather events, their perception of climate change has shifted, survey results show