A beloved character's unexpected comeback is explained by the show's executive producer, hinting at the possibility of future adventures