Basically, on analog media, playback speed isn't perfect. There's constant speedups and slowdowns. This creates a "waa waa" or "wow wow" effect that's noticeable when playing a constant pure tone.

don't forget that tapes also stretch so that can also give similar sounds