Content Sync provides you a couple of different update behaviours you can configure. See Pull updates here for details: Flows: Pull options .

One of the available options is to allow editors to override content locally after it has been pulled:

As you can see, the content form will only be visible after the editor explicitly flagged the content as overridden and the consequences are explained to them: