Linguist here. Endangered languages are a big deal right now.
The big thing that jumps out at me as potentially a game changer is the linguasoft. With a lot of disappearing languages, especially those in North America, one of the hard parts about teaching young people the language is providing an immersive environment, since there are so few speakers. With the advent of the linguasoft, now, you wanna raise your kids speaking Cherokee at home? Plop down a few hundreds (or maybe not, it's probably subsidized in the NAN) and get a linguasoft for you and your wife. Practically effortless. Same thing goes for teachers for immersion schools, preschools et al. Between that and the cultural shifts of the Awakening, I think some degree of language revitalization makes sense.
That said, a lot of languages might be too far gone, and SR has made some odd choices about which survive. Hopi and Zuni each have speaker numbers in the four digit range. Navajo is far and away the strongest Native language in the US, by comparison. Yet the former become prevalent in Pueblo and not the latter? That's dumb as all hell.
As far as which survive and would be prevalent if SR made sense...here's my personal bets. The Salish languages are probably too far gone, so I imagine you're more likely to hear Sperethiel or Cantonese in the SSC than any Native language. I could see the various Sioux languages making a comeback, though, and Cherokee is probably strong enough to hold its own inside the Sioux state. In the AMC, Cree, Ojibwe and Saulteaux (if you count that as sufficiently separate from Ojibwe) are probably all going to do ok. Hell, there's Cree monolinguals even today, just not very many. And all three of those have some degree of mutual intelligibility. The Ute languages are probably too far gone, realistically speaking, as are the northern Iroquian tongues. I could see Athabaska having some degree of strength for a variety of languages, especially in smaller isolated population centers like Yellowknife, but probably not a single dominant one across the vast region. And in the TPA probably there are a lot more Inuktitut speakers than English speakers. Then again, there are probably also more Icelandic speakers than English speakers, and a decent size group of Russian speakers, and many of these groups will overlap. Outside the NAN, like, in Australia the only group that has a shot at surviving is the Western Desert language/dialect group, which has about four thousand speakers, whereas most Aboriginal languages have, like, five speakers. Siberia I'm not as familiar with the languages in, and in most other places the minority languages aren't likely to come out in bad shape.
Sperethiel I've always imagined as a creolized mixture of Old Sperethiel, Dublin Irish and English, to explain a lot of the use of Irish terms as "Sperethiel". This would predict it to be strong in Tir na Nog at least, and I imagine others might pick it up as an elven lingua franca. And I imagine it's that lingua franca usage also driving Or'zet, which is probably closer to the original, as a language all orks across the globe can communicate in.