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-...
Going to Mass isn't something you just do for yourself. You do it to give glory to God, in remembrance of Jesus, and participate in communion with the Holy Spirit.
The Tridentine Mass in Latin is a way to reconnect with the apostolic lineage of the Church, the saints and the generations who came before. I can say with certainty that even modern mass in vernacular is nothing more than a bunch of mumbled repeating sounds to most people in the pews who zone out while they attend once or twice a year for Christmas and Easter.
If you've been to an Assyrian Orthodox mass, you might hear part or all of it in Aramaic. It's quite the experience, especially with the icons of the saints surrounding the community, adding a bit of a transcendental nature that is sorely missing in more "modern" church experiences.
From that perspective, what you’re saying maybe makes sense and that people aren’t really there to internalize the message, but are there for a spectacle. When my parents were growing up until about the 1960s or 70s, I believe all masses all over the world in Catholic churches were all done in Latin.
Maybe because a web site isn't holy Mass?