I've been to a Latin mass a couple of times, specifically a sung (aka high) Latin mass. I see why so many people prefer it. But the Novus Ordo can also be sung. Latin masses also tend to use incense, etc, which also used to be more common in the Norvus Ordo. The real division is between parishes and priests with the energy to put into the mass, versus those that fall into the habit of doing the bare minimum. The "Latin mass" just happens to be a convenient mechanism that bifurcates the two groups.
Relatedly, I read a argument somewhere that the current state can be traced back to the proliferation of Irish priests. In Ireland the low (unsung) Latin mass had apparently been for centuries the predominate form even on Sundays. I'm not sure how accurate that is, but reading various sources it does seem that in various parts of the world the sung mass had already been in a long decline at least since the 1800s. And I think the Norvus Ordo was intended to simplify things in the hopes of reviving the energy in the mass, but instead it just created a lower floor.
Regarding the Novus Ordo, I believe that the key document from Vatican II (Sacrosanctum Concilium) still preferred Latin as the dominant language in liturgy, while readings etc. stayed in the vernacular, but clearly that is not what happened.
There's been an uptick in numbers for Tridentine Rite, so tides might shift back as Catholics realize the wealth of their liturgical tradition.
The hulabaloo about the Latin or so-called Tridentine Mass is a cultural issue that is mostly about shifting societal norms and only incidentally about it's being in Latin. This is evidenced by the fact that the current form of the Mass, the Novus Ordo, is written in Latin then translated into the vernacular, and it can still be validly performed in Latin without special dispensation from the Vatican.
https://www.americamagazine.org/faith/2021/07/19/latin-mass-...
Maybe because a web site isn't holy Mass?