It really depends on the application. For a casual use app, the social logins are the smallest barrier to entry for the type of user they are targeted at.

Any "friction", like having to enter a username, email and password is three more steps than a social login requires, costing these casual users.

So, I can believe it is highly effective for specific applications.

That's a lovely theory and all, but literally nothing has a ratio of social:real registration anywhere approaching 24:1. Those casual use apps you are talking about get 70% social if they have really bad registration processes. Under 50% if they have decent registration.