I've off roaded my 2008 Denali all over the west on multiple back roads, washboard sections, etc and never once had an issue with the sunroof - never crossed my mind actually.
Being that the roof is a pivotal structure safety area, I don't see how you would develop enough flex to crack...