Even Gary Kasparov, Genoa Auriemma, and the Golden State Warriors fall off their perch eventually. It doesn’t mean they aren’t damn good at what they do.
I've had people I've casually (sometimes in a business context) interacted with on several occasions & gotten a very positive impression, only to late be told a lot of negatives from people who knew them better.
One guy in particular was praised by my boss (also his ex-boss at the time), confirming my positive impression & years later a coworker of mine who worked under that person had a very negative view of them...
There are several possibilities but I think the most likely is a combination of 1. people act differently in different contexts 2. the same person can be good at one position/time and bad at another 3. people are not always honest with you & especially if they're good at it can come across the way they wish.