With all the tripods I have had, the pin has either been spring loaded or removable, there is no problem mounting Sony cameras on third party tripods. Often the mounting heads can be installed in the clamp in either direction. It is a matter of researching the right tripod for the job.
My Sony Hi-8 camera "lived" on top of a Velbon tripod most of the time.
The only unfortunate thing about modern camcorders is that they are so small, especially compared to the "beasts" of yesteryear! The result is that they just look so silly mounted on a decent fluid head video tripod. All the cred has disappeared.