Only if the client-side scanning includes end-to-end encryption, which was never part of the deal. It was a possible future feature. Also, only if the-client side scanning only scans images being uploaded to iCloud and not literally everything.
Also any kind of content scanning is always strictly worse than no scanning at all.
