I had the same problem with two mazda tributes both had sunroofs.
There was a gutter that collected water that made its way naturally past the rubber,...