PVC for body tubes isn't THAT bad a choice, as long as the correct material is used. PVC water pipe is pretty fragile stuff. There are other, much stronger tube shaped PVC materials available.
Furniture grade PVC pipe has 4 to 6 times the impact strength of water pipe. In a 1" pipe, SCH 40 is heavy, but there are other wall thicknesses available. Eric, with BaddAzz Rocketry, uses 125 PSI pipe, which, in 1" pipe, has a wall thickness of .060"-.065", depending on the manufacturer (compared to a nominal thickness of .135" for SCH 40). Eric's rockets are MPR and HPR.
Furniture grade PVC has additives such a polyethylene and acrylic that increase the impact and tensile strengths of the pipe. The addition of polyethylene adds a safety factor similar to that of tempered safety glass. When high impact PVC breaks, it is usually more likely to break into smaller pieces, making it less hazardous than the shrapnel emitted from shattered water pipe.
While PVC may not be as safe or light as paper or cardboard, as a body tube, PVC is a viable alternative, as long as the motor will support the weight of the rocket.