While I understand the network effect of github for public project, I don't really understand why one would want to use it for private repos.

There are tons of git providers including free ones that include full gitlab/gitea/forgejo to get similar features to github and there is nothing more easy to self host or host on a vps with near zero maintenance.