Exclusive: US is less feared by its traditional adversaries, while its allies feel ever more distant, results show