Multiplex, thanks, very helpful practical info. One hangup is I don't exactly understand how 'resonance' is defined in relation to a turntable. Can you try to define it for me? Also, when you say 'microphonic', what does that imply?
Maybe microphonic isn't the best word to describe this, but I think that it works... I was referring to when vibrations are "picked up" from the surrounding environment and reproduced by a device, much like a microphone. It's a term often used for aging vacuum tubes that start "hearing" sounds around them. To be more accurate, I should probably say "easily excited resonances," but that doesn't have quite the same ring to it.
Anyway, resonance happens when energy is introduced that excites vibrations in an object. The resonant frequency is the natural frequency at which said object wants to vibrate. (Think tuning fork. When you tap it, it will always resonate at "concert A", or 440Hz because of it's size and shape.)
Here's an example of energies exciting a resonance:
I have a small decorative gong in my listening room. It looks kinda cool, but it is actually a pretty dumb thing to have in there. When I really crank my system, vibrations in the air excite the metal material of the gong causing it to vibrate sympathetically. So if I am playing a CD loudly and suddenly hit pause, I can hear this faint .. gonnnng... decaying in the background. It's not very apparent most of the time, and it doesn't really bother me. But it probably measurably degrades my listening experience.
Now, as far as record playback is concerned, it would work best when performed while isolated in a vacuum. Nothing but a stylus and a groove, the only motion being the forward velocity of the groove and the vibrations of the stylus as it follows the contours of the groove walls. Nothing added, nothing subtracted, just a pure reproduction. Unfortunately, that's not possible. The cantilever has a resonant frequency. The cartridge itself can have resonances, as will the headshell, and tonearm, etc. Then there are all of the ambient vibrations. The point of playing records is specifically for making vibrations you can hear, so naturally your turntable will be immersed in vibrations. When these vibrations are introduced back into the playback system, they can cause various different materials of it's construction to resonate just as my gong does.
All of these excess movements, vibrations and energies come back into the stylus during playback. All of these movements added over the top of the music waveform will cause distortions. Increasing amplitude. Decreasing amplitude. New and different "squiggles" in the signal that weren't present in the original recording. It can be a lot like my "gonnnnng...." going on in the background... Or maybe more like a cacophony of several gongs.
Resonances from compliance mismatch are a little different, but still operate on much the same principle. The tonearm is a big heavy lever, controlled by the far tinier cantilever, which is mounted in springy material. How they interact can be viewed more like a car with bad shocks. Most of the time, the car with bad shocks will still drive sorta okay. That is, at least until you hit a big bump, have to swerve, or hit the brakes. When "excited," a car with bad shocks usually bounces up and down with a certain resonant frequency. The car won't handle well, because the tires aren't held to the road well enough. Same goes for your stylus tip. If it's not well controlled, as soon as the the going gets tough, excess energies will begin to make it lose control.