Why does cold water sink?

It's because warm air is less dense

Because Any object or substance that is less dense than a fluid will float in that fluid, so hot water rises (floats) in colder water. When fluids are cooled, they contract and therefore become more dense. Any object or substance that is more dense than a fluid will sink in that fluid, so cold water sinks in warmer water