Schadenfreude is the feeling of joy you get from someone else's pain, as you and someone else said. Trump getting COVID wasn't schadenfreude, but many people (myself included) experienced schadenfreude from the knowledge that Trump was getting his just deserts.