A pinned connection is super simple when you see it but may not be the easiest thing to explain. It's something akin to this pic below. There is a pin that goes through an ear (tab, plate, whatever you want to call it) and then goes into the roof like, in this pic, the pin goes through the trailer side wall and then into the ramp. Pin can have safety clips, knobs, and various configurations. To secure the dome, PODs use a threaded bolt through the dome lip and into a threaded insert in the wall. Same principal for a ROR.
Embedding your sonotube down to 3" off the bottom of the foundation is not going to fall over or anything drastic. The paper is of no structural value so what you are doing is isolating the pier from the foundation except for the 3" of concrete at the bottom of the hole. It's not that it won't work. It's just that it's working against you in terms of performance.
I just mentioned frost heave because someone above mentioned that someone else mentioned that sonotube helped with frost heave. Unfortunately, it doesn't.
Regarding heavy duty garage door tracks: nothing wrong with heavy-duty anything but have you seen garage doors in your area blown off the walls? These are likely on standard duty hardware. Your ROR may have less wind loading than a garage door. Designing for high wind is not too tough. It's what's in the wind that makes things interesting. A 150mph wind is one thing but a hit by a 1,000 pound palm tree traveling 150mph in that wind is a whole different challenge to survive.