The frequency at which a resonant system oscillates is lowered in proportion to its mass. A liquid in contact with the surface of a resonant body contributes its mass through mechanical coupling, increasing the inertial moment and thereby reducing the resonant frequency of the system.
Stirring of the liquid in a vessel increases angular momentum in the liquid throwing it outward. With outward momentum confined by the surrounding vessel the liquid is forced up the side of the container until the force due to momentum is in equilibrium with the downward force of gravity. The resulting increase in the surface area of the vessel in contact with the liquid lowers the resonant frequency of the oscillations induced by the tapping.
As angular momentum dissipates and rotation slows the level of the water at the surface of the container gradually falls reducing the contribution of the liquid to the resonant frequency of the system and the pitch rises proportionately.
However, your probably referring to
the hot chocolate effect