git archive can work with a server with git protocol support (i.e. git server, smart-http and ssh server).
In your case, either your git is too old, or the server is dumb http server (normal http server, without “smart” git support). You need to clone the repository and archive from there.