How is Chinese Water Torture... Torture?

Please explain how dripping water onto someone's forehead is a torture method. Seems like it would be relaxing to me. How this torture method actually work and get people to confess?