The root of the UN's problems with Bush is...manners. BooHoo, he didn't ask them NICELY, he said "Get off yer butts and get the job done!" and they were all insulted.
Who the hell would want an ally who goes into a snit and abandons you over such piddly EGO issues? Let's say for the sake of argument Bush was rude or whatever--can't these "leaders" see the larger picture and think "OK, this guy's being a jerk but the real issue is important"?
Assuming, of course, we're talking about the non-bribed members of the UN.
Maybe ego was involved, but the Mexican Ambassador to the U.N. complained about British and U.S. spying, and the whole thing has given the Bush administration a very bad reputation in Mexico.
President Fox might have been able to convince Mexican opinion-makers on the wisdom of at least remaining neutral in the Security Council, or providing some token assistance (military assistance was out of the question -- besides not having a military capable of an overseas operation, Mexico's constitution only allows for overseas operations if Mexico itself is attacked).
Casteñeda and Ambassador Aguillar Zinser quit. They were the last remnants of a small left-wing, pro-US, pro-Fox party that gave PAN its margin of victory in 2000. Fox, and PAN, looked like idiots after being "dissed" by the U.S., and suspicion over U.S. motivations is at an all time high. Congress is unlikely to pass legislation which would have supplied more energy (gas and oil) to the U.S.
The PRI and the PRD are winning local elections. The most popular politican in the country is from the Socialist PRD. Although his party has faced some serious scandals lately, anti-U.S. suspicions have kept him from losing too much support. Thanks to inept foreign policy, expect HIGHER Mexican oil prices, and closer Mexican ties to Brazil, Argentina, the European Union and Japan at the expense of the U.S.