Many climate scientists said the joyful sentiments of world leaders did not accurately reflect the limited ambition of the agreement