It was the 10th time the Senate has tried to stop the war, and the outcome, on a vote of 50-48, was a stunning turnaround from past efforts