They'd probably quickly stop cheering as their own homes and families were destroyed as collateral damage, which is what would happen if the "full force of the US military" were deployed against the cartels.

The last time America invaded Mexico City it created martyrs. It's a fascinating story that they do not teach at US highschools lol.