Not to say there isn't any overlap. But whereas people who are smart but somewhat lacking in social skills can thrive in nerd-dom, for people in the lowest quartile on both, paid employment is a race to the bottom.
(Side note - HN tends to hypothesise that smartness and social skills are inversely correlated. While there's certainly a trend for people to develop one at the expense of the other, there's not much correlation in innate levels).
Video games and porn play the same role here as weed has for at least the last couple of generations, and alcohol for centuries - they make an otherwise intolerable situation tolerable. If you've genuinely no escape from your circumstances, that's a good thing. If you might otherwise sort your life out and become a positive contributor, but they rob you of motivation to do so, not so much.
I wouldn't like to say which side the numbers come down on overall. When does taking the edge off go too far - harder to measure this when you don't have the direct indicators of health damage or violent/abusive behaviour that alcohol brings. Modern society tends to assume that the right amount of motivation to have is "as much as possible", but that's not always true.