Thinking of the material, I doubt the choice of metal would make much difference because the sound is produced by the vibration of the air, not the wall . I believe (cathedral-size) organ pipes are made from a fairly soft alloy rather like pewter.
The advantage of brass over copper is that it is tougher for the diameter and thickness.
Comparing metal to wood-wind is different as wood is somewhat absorbent, and that probably according to frequency so affecting the harmonics that give the instrument its timbre.
'
Incidentally, somewhat tangentially to the thread but having mentioned organ pipes, it's well worth exploring the web-site of organ builders Harrison & Harrison, for a fascinating and very informative stills-gallery showing these huge and very complicated instruments being built. Including making the pipes. I had imagined it nowadays all CNC and synthetic materials, but no; whilst individual parts might be made like that the assembly, in the firm's very up-to-date factory, involves considerable, highly-skilled manual fitting; a lot of it in wood.