Answer
Before assuming the deployment failed, confirm the projection was actually part of the delivered package, that its permission set was granted to the calling identity, and that you're checking the same environment it was deployed to. See connect a projection function and discover an API contract.