See
https://skyandtelescope.org/astronom...rophotography/
There are arguments for both. For scientific imaging then perhaps CCD, for pretty pictures it probably doesn’t matter, for planetary and lunar ’lucky imaging’ then perhaps CMOS.
See also
https://www.atik-cameras.com/news/di...-cmos-sensors/
There are many other references online.
Disclaimer. I am not an astro photographer. There are just too many quality images by too many others for me to want to pursue that interest. I like and prefer seeing astro objects through an eyepiece. When I want to look at pretty pictures I browse through the coffee table book on IIS galleries. Whichever camera you get I’m sure I and many others will enjoy your images there.