While it does feature Adam Sandler impersonating a variety of characters, including a gruff, Springsteen-esque singer, it's not specifically about a turkey. The song is a humorous take on a family's Thanksgiving dinner, featuring the different personalities and quirks of its members.
So, while it's a funny and memorable song, it's not actually about a turkey and it wasn't performed on Weekend Update. 😊