Not in my experience. I’ve had multiple 15+ year vehicles, with sunroofs and none of them leaked. If there was water, it was the drip tubes getting clogged. All you had to do was run a straightened out coat hanger down the tubes. Granted, these all were Honda’s and our current Toyota.