CS majors that understand programming but don't want to be programmers can add great value in a number of areas including technical support roles, consulting roles, pre-sales engineering, professional services (helping companies to implement software), product and or project management, analysts, etc.

Some questions to think about - are you good with people and can you do well in a customer facing role? If not perhaps some of the more individual roles would be better.