A longtime Saturday Night Live star is leaving the show amid a string of high-profile departures that have left fans shocked