The president insists the war is worth it. An American majority disagrees