So sad. I have pretty mundane dreams, so I usually don't remember them.
And my school offered French, Spanish, and Italian. At one point it offered German and Japanese, but alas, those were cut from the budget before I got there.
The school I went to before forced us to take Spanish and one year of French, so I know plenty of Spanish, plus some rudimentary French and a little self-taught German. Plus some Maori that I picked up because of reasons.
And yeah, technically there are some families that have that older nieces or nephews, but that's more an exception than the rule.