A survey of some 37,000 people across 33 countries found scepticism about US President Trump's foreign policy agenda.