Some of these responses remind me of the old ‘Ditka’ sketches on Saturday Night Live…
Brats-And-Beer Loving Chicago Bears Fan #1: “so… John Maddan versus Ditka… who wins?”
BABLCBF #2: “ah… Ditka… no problem.”
BABLCBF #1: “okay, so how about the whole AFC east against Ditka??”
BABLCBF #2: “not even close… Ditka.”
BABLCBF #1: “here’s a tough one… The entire free world against Ditka…”
BABLCBF #2: “Ya, dat’s a tough one… let me see… Ditka!”
etc…
Keep your knee-jerk “'USA ROCKS!” in check please… first of all we are talking conventional war here, not nuclear (which is a relief for you flag-wavers 'cuz if you include nuclear, then several nations could obliterate us RIGHT NOW, with a little luck)
It’s hard to even imagine a USA vs China/Russia war reaching a military conclusion (without nukes) as the destruction and loss would be so great as to almost guarantee a settlement of some sort. But that wouldn’t answer the OP, would it?
So… forget about your air superiority right now… the Luftwaffe had that in 1939 and golly, look at them now. In WWII the USA was able to drastically increase its industrial production to meet the needs of the war. I suspect a 2003 coalition against the US could also rise to the challenge of desperate wartime materiel production.
And let’s not forget that there are countries with (currently) greater land forces than the US (for example, the PLA), plus the willingness to take much larger casualties.
In Korea, the superior US air power and armor weren’t enough to gain the victory because the UN forces were hampered by a political decision to never strike north of the Yalu (in China). In the hypothetical situation of the OP, the American military would be similarly hampered by the ‘no nukes’ ground rule. (of course the ‘enemy’ would too) Whereas large numbers of expendable infantry on the other side would help keep the battle at least at a stalemate, IMO.