A majority say the war is not in the national interest, and many lack confidence in the president’s goals — including some 2024 supporters.