I'm also from the UK, and I was lucky enough that my parents used a cunning trick to get me into a good school[0], I'd like to add that even when the school is good, the expectations people have for you can make a huge difference.
I am terrible at the French language. I could never get the verb conjugations into my head, and trying to do that is one of only three memories I have of the entire learning experience from Year 7 to the start of the exams. Somehow I managed to end up in the top class for everything, including French. I found it really stressful and asked to be moved down to the middle group, and the teachers agreed — but as soon as I did, I found nobody, students certainly and it felt like also the teacher, was even trying in the middle group. While it stopped me being stressed, I ended up with a GCSE grade D in French, my joint-worst with R.E. (guess who wondered into the New Age section of Waterstones and decided Wicca was a lot more interesting than the Bible, while still a student in a Catholic school with mandatory Mass attendance and R.E. lessons).
For university I went to Aberystwyth[1]; I never even considered applying to Oxford or Cambridge, because Oxbridge is the best-of-the-best. When I graduated and got a job which happened to be in Cambridge, all my new friends assumed I was a fellow Cam grad, and I rapidly developed a regret I hadn't even tried to get in[2]. I might still have failed if I had tried, but I didn’t even try.
I enjoyed learning German at school for the one year I was allowed to (hence moving to Berlin a few years ago), and like your general resentment, I resented having French GCSE forced on me when I sucked so much at it. And the R.E. lessons, too.
[0] A Catholic baptism because the best local school was Catholic.
[1] Owing to a misunderstanding, a friend said they had a lot of fun there when they were a student, but it turned out they were talking about the town and visiting friends as their university was a completely different one.
[2] Thanks to a convoluted series of events, I can technically say I studied in Cambridge university as part of my degree; but this is because my industrial year job sent me on a training course in the William Gates building. This is also how I was in New Hall despite my beard and it being a women-only hall.