I think there is all kind of people that work as a computer programmer.
So even though there are some with a ver wealthy social life as you mentioned, the typical programmer must also exists out there (the nerd that works late in the night, again, as you mentioned)
But as this kind of job become more and more popular, the type of people that study this will become greater as well, so yes, the typical programmer will become less common as time goes by.
Adapting the revolutionary flow of millenial programmers. :D