Millions of dead Vietnamese.
In any case that was a war against a hardened, experienced, determined enemy fighting for its freedom from any form of colonial occupation, both as a formal military and as an insurgent force in South Vietnam.
I scarcely think the Mexican population would rise up in defense of the cartels here.
I think a lot of people would be cheering on the destruction of the cartels.
A non-aligned population will look out for their own interests and are aware that the attention of the US is temporary but the cuadillismo that lead to cartels are a durable cultural artifact.
https://en.wikipedia.org/wiki/Battle_of_Culiac%C3%A1n