I think its more nuanced than that. I am very shy, but I think have done okay largely through being ambitious, which cut through shyness at key times. A lot of people I work with are the same story I think
That being said, there are a variety of other character traits that play a role in how different people reach success, thus part of the issue is simply the interpretation of "success" itself, because quite often we look to very specific examples of successful people (e.g. Steve Jobs) or paths, that don't suit our personality taits nor strengths at all, and set us up with unrealistic expectations for ourselves.
Success comes in all forms, shapes, and sizes, so there should be no reason to let certain traits limit us on the hunt for success, when the game is largely about filtering out the noise and focusing on paths and pursuits that actually play to our strengths, instead of ones that make us perpetually anxious and stressed out.
I hear a saying a while back and I'm murdering it but "Introverts recharge by themselves and extroverts recharge with other people" and that is me, in small stints I can be gregarious and outgoing but within a short period I just want to be on my own again, I find it tiring.