You've been watching too many movies.
The purpose of the CIA is intelligence - i.e. finding out what the other guy is up to. That is the type of thing that is needed right now in the Middle East - Finding out where the next terrorism act is going to take place, so that you can intercept.
99% of the CIA's work is spent reading, listening and interviewing. The people who do it are basically the brainy nerds you laughed at in high school. None of this 007 stuff.
The only thing you should feel when shooting a terrorist: Recoil.