Physics! Standing wave resonance of an expanding air column.

As the hose gets longer, the vibrating air column (inside the hose) gets longer. Longer wavelengths correspond to lower frequencies, so the pitch decreases as the hose lengthens.