If they can do a manual review at all, then there isn’t end to end encryption anymore, so I’m missing what the point of client side scanning is.
Most people don’t really want end to end on consumer backup services, because of the associated risks. If however you don’t want unsecured backups you can handle this manually.
Of course nobody wants the company to actually look at your data, but that’s a separate issue.