The water distribution pipe is responsible for transferring coolant to specific locations throughout the engine cooling system.