You are right, but by local-only photos I meant "not using iCloud photos" - e.g. "none".

The point is, I think if Apple decided to scan your photos for CSAM even if you weren't using iCloud, that this would be a distinctly different situation to scanning only the ones uploaded to iCloud.