Actually, backlash is putting it too strongly. First of all, GW Bush is not a vindictive man. He'll still be saying Fox is his friend next month, and next year.
Plus,the American people aren't vindictive. Some here won't like Mexico for it, but, well, they didn't like Mexico before.
Now, if Mexico had sided with us on Iraq, America's attitude towards Mexico would have become more sympathetic. It might them have become even easier for Mexicans to sneak into the US, for example. This way, with Mexico obviously against us in the Security Council, nothing will change.
Undoubtedly Fox wanted to side with us, but his foolish public has too much self-defeating resentment against America.