Probably not it's not like this would be a new thing for the U.S army.
I don't think you comprehend just how much Maya there were, and how good they were at fighting.
This isn't the US army is sent out to the Midwest to wipe out isolated units of 500 or so people, including women and children. This is the US army being sent out to a very far place, very distant from reinforcements (with no trains and roads to get the new contingents there quickly) to take down a very densely populated population that numbers in the hundreds of thousands. A population that is both organized, numerous, determined, well trained, and lives in a very rugged, very tropical and very disease ridden terrain that they know like the back of their hands.
And one that was, above all that, very well armed, being eager buyers of the British, who most certainly will be even more terrified of the American behemoth and have an interested in lowering the balance of power, so they'll sell their guns and artillery at discount prices.
Please tell me how the US will just waltz in there and deal with that with no problems whatsoever.
This of course ignores that the press, who will just see the Yucatan campaigns as a quagmire in some God Forsaken hellhole where America's boys are getting slaughtered day and night.