I've visited Mexico with my Spanish-speaking wife (semi-natively) and while the locals loved to hear her speak their language, we communicated mostly in English if we wanted to be easily understood.
The struggle is real for Americans, or for native English speakers as a whole. For Americans, there is no other language spoken for thousands of miles like you mentioned (Mexico and Quebec (to a limited extent)), and even then, most of the people we interact with on vacation will speak English.
I put serious effort into maintain my German, and she puts serious effort into maintaining her Spanish. But we rarely have the chance to actually use it, even if we're in a country that speaks the language. English has won.
I have been learning Chinese in China for about 7 months, and have a functional command of most conversations because I never ever use English during those conversations. English will always win if you keep biking with the training wheels on.
When I lived in Cambodia for an even longer time I didnt learn nearly as much Khmer because I was constantly speaking in English, even though I diligently listened to Khmer conversations and researched the language. Like programming, language learning is much slower as a spectator sport.
In my travels, I've yet to run into someone who I really need to talk to who only speaks their native (non-English) language.
And feel free to drop me a mail and have a call if you want. :)
There's this common argument that prescribes utility to studying Latin via the value you gain by understanding biological, legal, and religious terminology.
I think that the net utility that you gain through this mechanism is approximately zero. Or rather, the net utility over other, more direct methods of acquiring this knowledge is zero. I think you could gain the requisite understanding of Latin to gain 99% of this utility in a few weeks of study, and that if understanding these roots is so important it should be material in our English classes, not in a long-term study of the Latin language itself.
Besides the "it helps you to know roots" argument, the study of a language gains utility largely in being able to speak the language, make do when traveling to places where the language is spoken, or consume the literature and media in the language. Moreover, the utility you gain from the language increases exponentially - a year of (half-assed, high-school-level) study is pretty useless, but after a few years of it, especially with higher (college-level?) standards, it's immensely useful because it opens you up to whole new worlds.
I think the best argument for teaching languages in high school is that this exponential growth starts earlier and is more likely to ever happen (especially for people who don't go to college or don't study languages there) if we start earlier.
Granted, there's utility gained from appreciating the culture of the language even as you learn the beginnings of it in high school, but I think that's dwarfed by the long-term potential for useful bilingualism and having the ability to more more easily experience new cultures.
--
also, anecdotally, my bad Latin has given me essentially 0 utility in my entire life since high school. Perhaps I got a few novelty realizations here and there, like identifying that "tractor" came from "trahere" and "et" means "and" in "et cetera", but those are trivial. Maybe my experience was unusual and others gained more from it. Also, admittedly, I can't really quantify or remember whether it improved my SAT scores or whatnot, but my overall assessment is that my Latin study was negligible.
Arguably, you could say that about many bodies of knowledge as much as Latin. The question is really: What percentage of people take that mandatory one year minimum of high school language and really build it into something valuable? I think it's pretty low. And,
bad German < bad Latin < good Latin < good German
U.S. school systems generally are simply unwilling to invest the resources needed to get kids really bilingual.
I do think that if all language programs are bad at a school then bad-Spanish would still have a higher utility than bad-Latin.
The United States is largely monolingual in English for a thousand miles, and the language ideology here causes immigrants to want their children to shift to English monolingualism as quickly as possible. And thus bad Latin is more useful than bad German.