You may be confusing CSAM detection for iCloud Photo Library with a new parental control feature for under 13s in the messaging app.
The child protection part can be enabled for under 13s if they’re in a family account. If enabled messages app will try and detect adult images being sent and received and give a warning to the child, it can also let the parents know about it.