The app is courtesy of François Simond, a.k.a Supercurio, who put it together in just four hours. Unfortunately, the app will currently only detect whether or not Carrier IQ is on your device, but can't do anything about it. Of course, being the good samaritan that he is, Simond has put the code for the app on Github, so other developers will surely expand on his work. Simond also warns that anti-Carrier IQ fixes are not detected and can lead to false positives, but these issues should be ironed out going forward.
You may not be able to actively kill Carrier IQ, but this is a knowing-is-half-the-battle type of situation where you can at least be a bit more careful with your phone. Or, knowing that it's on your device, you can contact your carrier to complain about the software.
If you want to give it a shot, the Voodoo Carrier IQ detector is available for free on the Android Market. And, if you're a developer looking to build on Simond's work, the code is at Github.