US president says he 'could not agree more' after prime minister backs Palestinian statehood at UN General Assembly, but others note absence of actual movement toward goal