There has been an article that deals better and less click-baity with that claim. Spoiler: there is not much evidence that Apple performs CP detection.

https://eclecticlight.co/2023/01/18/is-apple-checking-images-we-view-in-the-finder/