I think you are focusing on the survivorship bias in role models, as those successful people in your life who you view as role models are more visible to you (the younger person) because they succeeded.

You wouldn't pick someone who ended up a Uber driver, because they dont look to you as someone from your field to model your future on.

Ultimately, getting fired can drastically change your life. Either for the betterment or detriment to their lives.

I look at all the “role model” esque people in my life - they’ve all been fired from a job at least once. There are also plenty of people I know who I wouldn’t consider role model esque who are simply lousy employees (and probably get fired many more times than the “role model” types). I say role model types simply to mean “people who you would be surprised to learn were fired from their job”.