I think in many ways, CS is a very cerebral job. You really need to like it to be good at it. that being said, I know several people who were not "nerds" but completely love CS. (actually, they might have become nerds on their path to CS...hmmm...)