I am not familiar with the specialized cameras you mention....
But all DSLRs, all "mirrorless" and most of the mid to high-end compact point n shoot digital cameras now use CMOS.
The Nikon D200 mentioned was the last Nikon to use a CCD sensor. A friend who I worked with a lot was using a pair of those and was always reluctant to use ISO above 400. I was shooting alongside her with a pair of Canon 30D with CMOS sensors and was able to use two stop higher ISO with less noise problems (Canon was the first DSLR manufacturer to convert to CMOS in all their DSLRs, beginning in 2001.... all others have followed since). When she used her D200s at higher ISOs, she had to apply heavy noise reduction that made for significant loss of fine detail. When the Nikon D300 with CMOS sensors were introduced in 2007, she was one of the first in line to trade up from her D200s!
Now every Nikon, Canon, Sony, Olympus, Pentax, etc. DSLRs and most of their other types of cameras are using CMOS, which has continued to improve. Canon and Nikon both have made some "astrophotography" models over the years, too.... which were essentially CMOS sensor cameras with weakened or "cancelled" low pass or anti-alias filters (Canon 20Da and 60Da, for example). Today there are a number of DLSRs that have weakened or cancelled AA filters anyway (such as the 50MP Canon 5DS-R, 46MP Nikon D850, 42MP Sony a7R III), so AFAIK they no longer make specialized models for astrophotography.
Low pass filters were used over both CCD and CMOS sensors to reduce moire in images. That's an optical issue that can occur when photographing anything with a repetitive pattern. Moire is caused by the "Bayer array" of pixel sites used with both types of image sensors. The AA or low pass filter deliberately blurs the image slightly, so it needed to be re-sharpened in post-processing (either in-camera or in computer). This also cost some fine detail. The cameras now being made without those filters - to gather every last little bit of detail possible - use other methods of minimizing moire, or leave it up to the user to remove it from images if necessary.
I don't know if this helps or not... It's not a direct answer about the specialized cameras you're consider. But it's fair to say that among DSLRs and many other types of digital, CMOS has proven superior and won out over CCD. Medium format digital continued to use CCD for some time longer, too... but also have largely converted to CMOS now, too. At the other extreme, even many camera phones are now using tiny CMOS sensors. Her'es more detailed info about CMOS (also called "CIS"), it works, is manufactured, and has supplanted CCD:
https://semiengineering.com/cmos-image-sensors-cis-past-present-future/