Well, it works to every repository the user who is doing the spoofing has access to, private or public. If the user has access to your private repository via the GitHub ACL, they'll be able to create a PR to it with their spoofed profile.
But yes, if you have a private repository only you and dependabot has access to, no user would be able to perform this spoof against your repository.