The real issue is not height of sonotube to the depth of the footing but the depth of the footing in relation to the width of the sonotube.
Force from a pier is directed downward and at the bottom of the pier the force is then dissipated straight downwards through the footing as well as at a 45 degree angle downwards and outwards from the outside walls of the sontube.
So, the rule of thumb is: Make sure the footing does not extend outwards from the pier or sonotube more than the depth of the footing.
Otherwise, the angled downward force can break off the part of the footing that extends beyond this 45 degree force line.
So if the footing is 8" deep, it should not extend more than 8" beyond the outside wall of the pier.
Tough to explain in words but simple with diagrams.
I won an inflatable 6 person inter hot tub. I have a large deck. 12x 20 on both sides of the house. With a header to the house and the deck was built 6
I'm putting a swim spa into an inground concrete bunker and will build a deck around it. I have been advised to keep the deck joists a minimum of 6 inches