I think the problem isn’t that our role models are unrealistic, so much as who we pick to be our unrealistic role models. Looking back now, I see that most of the fictional characters I was presented with as role models were men who were really good at fighting, and at saving the semi-helpless women to whom they were attracted.
That’s not great, but it is better than what girls got for role models, which was women who were really good at being attractive and imploring the boys’ role models to save them.
Indiana Jones and Marion Ravenwood could have bucked that trend. They at least had other interests beyond fighting and being attractive. He was a professor and a scientist. She was a small business owner and a successful competitive drinker.
Of course, as a Hollywood film hero, Indiana Jones needed to have a different girlfriend every movie. He moved on to a squeamish damsel and a backstabbing Nazi, fine role models both!