I believe its destiny is to preserve the Catholic Church for saner times when future generations will understand better what went wrong and how to get back on track.
The Indult Tridentine Rite, as I mentioned in a different post, is alive and well in many communities. It will survive for as long as there is a demand. However, there is NO GOING BACK! The Novus Ordo the liturgy has been embraced by millions of catholics around the world. And, yes, most practicing catholics do find God in that liturgy.
I make it a practice to tell everyone I know about the beautiful Tridentine Mass we have available to us in Boston. The location is very easy (although an hours' ride) and so beautiful, especially the High Mass with the Gregorian Chant, that it makes you want to cry. I tell them that the statues are intact, candles galore, Tabernacle is front and center, traditional music, communion on the tongue, a wonderful, holy priest and proper dress (including a head covering) is the norm.
Ya know what? NO ONE I've mentioned it to has ever actually attended it. They express surprise that there is still a Latin Mass, but no interest in attending one.
IMO, it's too bad as they could see firsthand what they should use to measure their own parish NO (and see what we have lost in some of the less orthodox NO Masses), but the bottom line is, Latin is not going to be the norm, ever - especially in the future generations.