as far as i know both brad pitt and george clooney used to be rather self-conscious and socially awkward in their early days, before they had any success in their careers. not sure that constitutes as "having social anxiety" but i thought id put it out there.
as for historical examples, many great or not so great leaders have gone through periods of depression and anxiety.
there is a point to be made about having to learn how to deal with adversity in life and ultimately becoming more succesful than the average person for the exact same reason. most people dont have to go through all this just to get to a somewhat decent place so they never bother improving that much. once you figure out how it is done, and get past your limiting beliefs, you are actually stronger than most people.