I love time loop stories and this one exploited all the tropes to good effect--and made sense in the end (although the set up kind of predicted that if you were paying attention).
How come no one ever references Dick Lupoff's story "12:01 PM" from the December 1973 issue of THE MAGAZINE OF FANTASY & SCIENCE FICTION or the 1993 movie of the same name (same year as GROUNDHOG DAY) plus the 1990 short film with Kurtwood Smith (there's your Star Trek connection)--the plot of which resembles the plot of this episode more than GROUNDHOG DAY.
Not only was this a fun and funny episode, it also got me deep in the feels. So much information to unpack. And the end scene with Mr. West had me cracking up. He's going to fit right in.
The episode title "Here I go again" reference checks ABBA'S "Mamma Mia" and Zari even says the line. Also Sara's outfit seems to be a tribute to Agnetha's from the video for that song. But the earworm for Mick is "Waterloo"--which won the Eurovision Song Contest in 1974.