It's just as tight.
Assuming you're talking about a reputable manufacturer's product, installed properly.
I have 2 Service Rifle Match uppers with the Armalite free float tubes on and the hand guards are rock solid to boot.
Also your sling is mounted to the end of the tube and a strong fellow like myself can put lots of torque on the tube so it has to be strong enough for everybody else.