The CSAM detection technical summary [1] only mentions iOS and iPadOS.
If it does come to macOS it will be part of Photos.app, as that's the only way to interact with iCloud Photos. I would recommend you to avoid that app and cloud in general if you care about privacy.
[1] https://www.apple.com/child-safety/pdf/CSAM_Detection_Techni...