Hi Stuart,
I well remember the hooter type whistle from when I was young – very deep sound.
I think that you need a considerably longer tube to make that deep note – look at musical instruments that rely on a blast of air. Try to read up LBSC`s instructions for whistle making. I can tell you that he said to keep the end open with a tight fitting piston on a rod protruding from the end of the pipe, so that you can adjust the effective length to get the desired sound. You might also do well to test on steam, not compressed air.
Regards,
John.