I'd like to risk being facetious and suggest that "being good with people" is a requirement for most good jobs, the ones where it's not are the first that get outsourced/replaced with robots/laid off.
Well, yeah. Admittedly the phrase "being good with people" is kinda vague. In most jobs you have to deal with people in some way or another. But when people use this phrase, they often mean something similar to "extroverted", "talkative", "persuasive", etc. Like for jobs in sales, these qualities (?) are often required and expected. However, I don't see how they matter much in a desk job, assuming you manage to communicate well (in some form or another) with your co-workers and clients.
There are different ways of being good with people. You can be good at talking with people you need to talk to, professionally, but not enjoy chatting about nothing with random strangers. Somehow not doing the latter makes you "shy". OK, so be it, but if you as a manager base your hiring/firing decisions on that you are a fool.