DevOpps and database synchronization
You mentioned a deployment package, therefore I suspect you may be talking about F&O, not AX. Is it the case? If not, which version of AX are you using and what do you mean by the package?
I'm assuming you're talking about a TFVC repository in Azure DevOps. Is that correct? (It would helped if you're more specific.)
Regarding "deployed on the server which contained the repo", please realize that the version control repository and application binaries deployed to F&O environments are very different things. The repository is in Azure DevOps (not in an F&O environment) and it contains source code . Then you build source code to binaries and create a deployable package, but it still doesn't have any impact on target environments. That happens when you actually install the package to an environment. DB synchronization is necessary, because there may be data model changes in the application and the new application wouldn't work with the database for the older version. F&O deployable packages therefore do synchronize the DB automatically.