If photos become E2EE, then Apple can no longer turn over said photos, while still not completely turning down their CSAM scanning obligations.
Google drive does not scan for child porn if the user uploads a user encrypted file. They literally can’t.
Personally, I don’t think E2EE photos is coming.