Floyd, since you're an engineer and a guy who at least knows how to hold a violin, here's the basics as I know them. Randy or Brett can point out where I'm wrong:
A tuned pipe works pretty much the way the air column on any wind instrument works -- pressure pulses go down the column, reflect off the end, come back, and then interfere either constructively or destructively with the pulses being produced at the head of the column.
In the case of a clarinet, flute, or whatever, the pressure pulses affect the sound being produced. In the case of a tuned pipe that's tuned for maximum power delivery, the pulses are timed to (hopefully) supercharge the engine both by making a vacuum when the exhaust opens to enhance scavenging, and by making a positive pressure right before the exhaust closes to provide a bit of supercharging. Adjusted correctly, the pipe is aiding the engine at the intended "best" RPM.
You don't want maximum power delivery. You want speed regulation, or better yet, you want the engine to speed up under load. In our case, then, you want the pipe to be adjusted longer than is "correct" for the jittering, excited racer standing next to you. You want the pipe to be adjusted so that at your desired RPM it's not really helping much at all, but such that if the engine speeds up a bit it actually interferes with the correct engine operation (by delivering pressure on exhaust open and/or vacuum on exhaust close); of course if you do that then if the engine slows down a bit it'll start helping. Moreover (and I don't understand this bit at all) if you run the right sized (smallish, compared to maximum power output) venturi and run the engine a bit rich, then when the engine gets loaded down the pipe will make it run faster.
Overall, the effect is that your airplane doesn't necessarily go faster than it would have, but rather that it flies at a more constant speed than it would have otherwise.