I teach German in a (Norwegian) high school, and I think your experience is typical. Most pupils forget everything they have learned as soon as they can after the exams, and only a very very few will go to Germany and make use of it.

And the Germans speak pretty decent English by now, so the payoff is not as great as it was.