This is exactly the reason why I'm against Apple CSAM. It's just a matter of time before someone innocent gets flagged.
Lots of parents take a photo of their child having a bath or something similar at least in Europe/Asia and it's clearly of non-sexual nature. Now, how does the Apple algo know that?
I'm generally curious: Have you tried to contact Google before about any kind of issue? It took me like a day or so to chat with an actual person the last time I had an issue.