I took three years of Spanish and got an A every semester. Even when it was still fresh in my mind, I was nowhere near able to hold even a very simple conversation. And now just a few years later it's all totally gone from my brain.
My mother's native language is Spanish and she never taught me, which I resent her for. But I still find it incredible how shitty my public school education in Spanish was. We really should be teaching kids a second language from kindergarten up.
Mine were actually super helpful and left me conversationally fluent in Spanish. Unfortunately not having anyone to speak it with in rural Canada in the years since have meant that I've lost the majority of that fluency.
I went to a really bougie school though, so my experience is likely not the norm.