After it was confirmed that Ernie's character had no chance of returning by executive producers, many fans took to social media to share their mixed reactions