It's been almost a decade since I started watching movies/tv shows, and playing games with original audio (usually english or japanese) and english subtitles instead of my native language, to help improve my english. But I to this day, every time I rewatch the movie Airplane, there are new jokes I hadn't understood before. It's one's of the reason I like to rewatch it every couple of years, the other being that it's my favorite comedy movie.
Good for you.
Sooo much is lost in the translations of Pratchett to other (even linguistically close) languages.
I mean, the translator try their best to carry the word plays or funny anglo-centric cultural references over, bu very rarely succeed in matching the wit and timing of the original English.
The French version, much effort went into it, and it is very good indeed, but nowhere near the original.
Some attempts at translating Pratchett's humor fall rather flat or completely miss the point of the original puns.
It depends less on puns, though. Those are always hard to translate. The Dutch translation (the one book I've read the translation of) Terry Pratchett is okay, but not brilliant.
[0] Edit: I thought Tolkien praised it. I'm sure I read that somewhere ages ago. Wikipedia tells a different story: that Tolkien hated it. Personally I think it's genius that names with a clear English vibe (like many hobbit names) get translated to names with a similarly Dutch vibe. Schuchart did not mess with the Elvish or other other languages as far as I know.
Of course Tolkien was a linguist so he could understand translation difficulties even in languages he didn’t speak. He went so far as to add fictional translation difficulties to his own story.
That said, from what I understand, Tolkien would later change his mind after the original Swedish translator took even more liberties, which provoked him enough to write an official translation style guide, and in retrospective light apparently the Dutch translation would mostly end up conforming to those guidelines.
The entire thing is pretty curious given the fact that if you want to get down to it, the framing devices of Lord of the Rings is that it is an alledged translation of a book called "The Red Book of Westmarch". Tolkien himself took liberties with this supposed translation, which is why many of the place names have some form of "common" English name, to make them more palatable to English readers. It's pretty interesting to see him then take offense at other translations.
[0]: As someone who fell in love with Tolkien's work from the Dutch translation - eh, it's fine? Most stuff is fairly faithfully and accurately translated. The main issue is that the translator was an even bigger fan of purple prose than Tolkien and occasionally used German roots for certain words. Most of the literal translations used are translated to what amounts to kinda formal, stiff Dutch but others flow fairly well. The biggest difference is probably the title which is something closer to "In the grasp of the Ring", which... might be more accurate to describe the events of the book. It's hardly about the Lord of the Rings himself after all.
1. De Heer der Ringen sounds very formal. It's because of both the choice of "Heer", which is a literal translation of Lord but is more commonly used to describe an old, respectable man. (The connecting word of "der" only adds to it, given "der" isn't often used nowadays.)
2. "In de ban van X" also nicely doubles as a Dutch saying; being in de ban of something means being enthralled by it. Which fits well with the overall motive of temptations that the ring provokes in those around it.
TL; DR: if there is one good translation, it has to be this one. If you read it in French, you are not losing much over the English original.
Another of my faves in English Asterix is a Goth; all their names end in -ic. This one is named Electric. In a fit of enthusiasm about being a war leader, he says. `I shall be a general, General Electric!'