CMOS has been developed further with the introduction of Scientific CMOS chips.
They seem to be quite a bit superior to their CCD counterparts. I can see being able capturing fainter details with one of these chips as the read noise is a fraction of CCDs.
Its early days and the first chip is only 5.5 megapixels but the low noise, high QE, fast frame rate with antiblooming could mean CCDs will have significant competition in the next few years.
If this line is successful we could see a future where CCDs are not so popular anymore.
http://www.scmos.com/
There is a downloadable paper on these chips if you are interested in reading more about it.
Greg.