HI John, here an interesting statistic from iSupply website. Somehow I feel on the Surveillance sphere the shift to CMOS is even more pronounced. I think a key reason might be that there is just no need for the CCD as the CMOS quality and variety has really improved over the last 5 years.
Maybe when doing extremely slow motion videos (such as capturing the motion of a water drop, etc) we might find the CCD to still be suitable given that you will find global shutter, high sensitivity (wihtout need of sense up or further image manipulation), etc.
I believe the average cost of CCD vs CMOS on a high megapixel situation is about 4 times more expensive. Also the programing of a CCD is quite more complex.
CMOS sensors have image processing functions within the sensor and also built in functionally like signal amplification, noise reduction, and analog to digital conversion.
With a CCD you have to setup a separate read time, shutter times, and excess charge dump time. And there are many cloks running that needs to be synchronized.
Thus the overall solution might be unnecesary more expensive with a CCD than a CMOS from serveral points of view that you see it.