Unfortunately, yes.
My 2005 AWD has the same problem.
There are not many aftermarket options available, I'm afraid. Seems the majors didn't put much effort into bolt on solutions.
If the pipe is rotted just around the connection and there's enough left to patch it (i.e., it's not completely broken off), I used a heat cured putty to fill the holes:
http://www.amazon.com/Blue-Magic-18003- ... B0084AA2LK
It may take a few tries to fill them, so don't use it all right away. The force of the exhaust can blow some of the uncured putty out of the holes, so put something underneath to catch any drips or you could try wrapping it with foil.
Haven't done it yet, but there are sellers on ebay for the complete pipe assembly between the manifold cat and the muffler (Davico brand) from $310 - $480 delivered. Look up "2006 Pontiac Vibe AWD exhaust".
The bolts at the joints will be pretty rusted, so you may need more parts to do this yourself...