The Mazda CX-9 does not seem to be too water tight.
My 1st leak was with the sun roof, when I would go through a car wash water poured in. Mazda replaced the rubber gasket and it fixed the problem.
The 2nd water leak was actually inside the A/C vent system inside the car. Had water sloshing...