Majority of Australians rate climate change as a bigger threat to the country's interest compared to global terrorism, a study has found.