No. In fiction, it is the flaws of the character that make them more compelling, realistic, and (sometimes) relatable. Perfect heroes in fiction often fall flat with audiences because there is no opportunity for the character to grow or overcome something, no meaningful character arc.
In real life, there aren't perfect people, and when someone performs a selfless, brave or compassionate act, they sometimes receive the title of hero, but they are still the person they were before, with their faults, flaws, sins, relationships, roles and every other facet that makes up a whole person.
Ghost of Tsushima. Speed-climbing up a cliff. At the top of a cliff, I get charged by a wild boar and it knocks me all the way to the bottom of cliff for a falling death.