I don’t think it defeats the point at all. Uploading photos to Google is a massive privacy concern. Apple is maybe better in that way, but very limited cross-platform support, and when I’ve tried it, poor performance & pricing. Neither do well at higher end photography either.
I self host for privacy, which makes me feel uncomfortable about all my private data sitting unencrypted on a server I don't control. It's better in that you don't have fully automated google AI scanning your data, but it's still exposed. None of the self hosted apps are designed with e2e encryption in mind so you'd be better off using icloud.