For my part I took Spanish from 2nd or 3rd grade all through college. I basically knew enough to be dangerous and it was occasionally useful in online chat where my broken Spanish was marginally better than some people’s non-existent English. But honestly the biggest strength was that I knew enough to be able to tell when Google translate did a bad job conveying my meaning.
Nowadays I’m several years removed from the last opportunity to use it at all and I hardly remember anything. It’s definitely a “use it or lose it” thing.