You're recalling "The Thanksgiving Song" by Adam Sandler, performed on Saturday Night Live (not Weekend Update). It's a holiday staple featuring Sandler impersonating various family members—including a gruff, Springsteen-esque vocalist—but it is not about a turkey; it's a comedic take on a chaotic family dinner.
The song appears on his 1994 album They're All Gonna Laugh at You! and remains a seasonal favorite.