I'd love to see some non-vendor-generated data that supported that contention. I think it's mostly myth.
An air horn would be louder, could be directed forward toward any on-coming threat, not backwards like pipes, and wouldn't annoy the neighbors. If loud pipes were a great idea, wouldn't all bikes have them? Wouldn't someone be making noise about mandating them?