Sentiment towards the US is deteriorating even among Washington's closest allies, according to Pew survey data.