Why is CCD still alive?
The main reason is that while CMOS has made great strides in overcoming it's limitations, there are still some advantages that CCDs hold.  I wasn't able to find anything completely up to date, but this article from 2017 has a few examples.

There's more ability to get consistent results from each pixel and get higher quality analog to digital conversion with less amplification necessary on the CCD.  The cost is much higher obviously as CCD has always been a more expensive option, but it still holds some specialty advantages.  If you need those advantages and have the money, it's still worth buying.

Looking at the difference between that camera and the next model down, you can see that the CCD does have a low light performance advantage over the closest equivalent CMOS camera in that line.