In the documentation Microsoft recommends that you use a copy of your database etc, what do you guys think would be the problem if going directly to a prod database?

Hello everyone! I was trying the git integration feature and was wondering if anyone have had the same problem as me? I created a dev and a prod workspace and a deployment pipeline. I went with the architecture like this: ---> dev-workspace git integrated and connected to the main branch ---> prod-workspace NOT git integrated This way lets me use the fabrics deployment pipelines in a combination with git. Everything seemed to work correctly until I wanted to remove something from the production workspace/main branch. I made a change in the main branch and updated my development workspace so the changes were synced to fabrics (everything works correctly with git), but when I try to deploy the development section in the deployment pipelines to see the changes in production, it wont deploy and sync correctly between the dev and prod pipelines. The prod environment highlights that the change I made to the dev workspace does not exist in prior stage and therefor cannot sync. It does that because I removed something in dev that still exists in the prod workspace since the deploy wont go through. Does anyone know why this happens? Or am I making a mistake somewhere?