No, they don't get paid. Its just an easy way to integrate your app with some sort of login/authentication floe, rather than building your own.
There are SSO solutions besides google. For example, Keycloak is open source but it is a PAIN IN THE ASS to manage it and set it up properly. Most people take the easy route and I don't blame them.