No. Tripod sensing is based on vibration measurements.

While it might seem logical that a camera could sense if something is attached to the tripod socket, they do not do that. The reason you state is enough since quick release plates often stay attached. Other accessories attach to the tripod socket such as flash brackets, camera slings, etc and would cause the same problem.

Lenses have to detect vibration to stabilize and so on some models, the use the characteristics of vibration to guess they are attached to a tripod. It may incorrectly guess, so it better to turn off stabilization yourself.

Pentax cameras use in-body stabilization (just like Sony Alpha and Olympus models) and so there is no stabilization switch on the lens. It would be annoying to have to enter the menu (or interactive status screen on some models) in order to toggle it on and off. Luckily, they have a much better prediction system: Stabilization is automatically turned off when the Self-Timer or Remote trigger is used. This solves the problem in such a way that no action is required except setting the self-timer or remote-trigger drive mode as you would be often doing anyways when shooting from a tripod.