Really sucks to see how awesome the new MBP is. It's too bad the CSAM scandal had to happen; never buying another Apple product again because of that shit.
Like a lot of apps, you don’t need to use Photos.app. They didn’t sneak it in without explaining how it worked.
CSAM is an abbreviation for "child sexual abuse material", so no, that won't (hopefully) get added without your consent.