The seal around the sunroof is not meant to keep weather and water out. The sunroof operates on a gutter and drain system. Water gets past that seal by design, collects in a gutter around the sunroof and drains through the body to the ground. The drains are most likely clogged. The drains are located at the front corners of the sunroof "pan" - meaning the sunroof should be open and there are two holes at each of the front corners. They may be somewhat obstructed from view by the wind deflector which pops up with the roof open. I clean the drains with bursts of compressed air. You can actually pour water into the gutter around the open sunroof and test if the drains are working. I think they travel through the A-pillars and deposit water down near the mudflap.