Has anyone experienced a water birth? Is it really pain free? Would love to hear about real experiences :)

I have a friend who just did water birth at NUH few months ago. She shared with me, the pain is much more manageable with water birth as compared to lying on the bed as the body feel light and comfortable in the warm water. Also, her husband was holding behind her and actively involved throughout the whole process and she feel loved and supported. Also, she hired a doula to assist with the water birth and guided her throughout the process. Overall, the water birth is a pleasant experience for her and her husband.