In person it doesn't sound like the car is falling apart at all, more like gas flowing very fast. It's a very clean 'pssss' noise.
I tried to rev to different RPMs in this video to give an idea of what the ARTs sound like at each. In the first revs you can hear the hiss. Note that this is with Berk's exhaust installed which seems quieter than most.