Dubya, Live in Turtle Bay: I didn't see the speech, but I read it. The first thing worth noting is that Bush offered little in the way of conciliatory gestures. In fact, he said rather bluntly that the "coalition" was forced to pick up for the slacking UN:

The Security Council was right to vow serious consequences if Iraq refused to comply. And because there were consequences, because a coalition of nations acted to defend the peace and the credibility of the United Nations, Iraq is free.

Far from being a crawling-back-home speech, this was more of a "Isn't it about time you got off your diplomatic asses?" speech.

As an original signer of the U.N. Charter, the United States of America is committed to the United Nations. [Unsaid, but clearly implied: "Even if the UN itself is not." --Eno] And we show that commitment by working to fulfill the U.N.'s stated purposes and giving meaning to its ideals.

My best guess is that France will have a brief fit of ugly, repugnant pique, but we will get a new resolution over a silent veto -- that is, France will not actually veto, but will stand around and look haughty while it abstains. Who cares? The resolution will be essentially meaningless, and will inspire few to join us who are not already with us, at least not in any serious way.

Oh, wait: Dubya will come out with a symbolic victory, a small shred of evidence -- in the form of a resolution -- that he can play nice with others. This and $3.50 will buy him a cappuccino in 2004.