Fans of The Simpsons were left shocked as one of the show's most legendary characters was 'killed off' in the season finale