There's a difference between being scared/incapable of going out and choosing deliberately not to. Some people, myself included, prefer our own company to those of others.
That said, I think it's a real handicap that can be overcome, like any other, by consistently pushing ourselves to go out and be social in some appropriate way, on a regular basis.
If you're making something truly cool, I guarantee there are people out there who might not be your target audience, but might know someone who knows someone who is. You'll never make that connection unless you go out. It sucks but extroverts have a big advantage in these areas.
But in practice, choosing to be social instead of skulking around on the internet or watching TV by myself at home has turned out to be the right choice 100% of the time.
"When in doubt, go out."
If I ever find myself asking whether I should go to an event/party/meeting and the alternative involves staying home, I go out. It's always the right choice.