Even if you never use it, get it, so atleast you're a statistic for the good guys.
As for getting pulled over; I've heard most folks get OUT of tickets due to havin a CCW. Reason being: You get pulled over, cop walks up, you say something to the effect of, 'Sir, I am a licenced CCW permit holder and I am carrying today. How would you like to procede?'. Right then and there, you've gotten on his good side by showing him you have nothing to hide and you're looking out for him. Cop likes you, and you have a better chance of getting off.
And a CCW permit shouldn't be used against you if you have to defend yourself. It's a legal privledge. Having a mindset to defend yourself, or your family, is nothing to be ashamed of.