You're right, it doesn't play a tune and it never will play a tune. This is intended behavior. This is not a bug. One block doesn't play a song. It isn't a flute. It makes a limited range of flute sounds that you can tune, and they fire whenever you are close enough in proximity... and if you remain in proximity it'll keep firing. That's what it does. That's it.
If you want it to make music, make a bunch of them, line them up and tune them... then walk past them. That's how you get the mermaid's golden walnuts on Ginger Island.