Every time I've ever had my sunroof leak, it was never the seal, it was always one of the four drain hoses that had clogged. But if the weatherstrip looks terrible I guess replace it.

as a ####, I swapped out my whole entire sunroof assembly haha. Trim was almost new, but still leaked, I was so frustrated to learn about the drains clogging. Oh well, live and learn.

good luck! and share pics of finished work!

The screen name says it all