Britain, China, Germany, France, Saudi Arabia and many other countries have rejected the US president’s deeply controversial proposal