It's resonance. Like a musical instrument, different shapes and sizes make certain notes louder. Larger volume - lower note. Smaller volume - higher note.

So as you fill up the glass/bottle/whatever, you decrease the air volume, making the sound pitch up.