This is valueable in an offline-first environment. In that case your app works locally fine, without any network connection. Synchronising is between the local database and the server database in the cloud (read more here: https://docs.mendix.com/refguide/offline-first)
Auto synchronising means that the proces described above will be triggered automatically after hitting the button and of course if there is a network connection to make sync possible.