Is possible to use Sign In With Apple on a website without an actual counterpart app on AppStore?
Yes, you can use Sign in with Apple JS. You do need a paid developer account in order to set up the required certificates and identifiers but you do not need to publish an app.