I've thought a lot about why that thing is so terrifying. I think the main thing is not just that the inanimate statue is coming to life, but that Bert doesn't believe Ernie when he tries to tell him. Trapped in a pyramid with a malicious mummy, and he's the only one who knows… Yeesh.