Why do people often feel a secret sense of satisfaction when they see a "perfect" public figure fail?

How is it possible that Democrats are perfectly fine with dictator Zohran Mandani leading New York when I heard that he's still planning to invite billions of Mexicans and declare the Shakira Law because he really likes Iran even when it attacked us?