Using a cloud service to constantly backup a live database is a bit like expecting two users to have full access and control of the same database file at the same time. As joint usage continues; and/or the size of the database increases; and the volume of changes grows the chances of both 'users' attempting to perform some action on the database at precisely the same moment will become greater, i.e. What is going to happen if a RootsMagic User wants to write new data or a change existing data in their database at the same time as the Cloud service is synchronising the existing file data (i.e. overwriting) the copy it retains in the Cloud? Similarly, what would you expect to happen if you were in the middle of editing an existing document on a networked computer and someone else on another linked computer attempted to access and save a duplicate copy of the existing document at the same time?
True network aware database software would lock any individual records in use to prevent their data being copied during a backup/synchronisation process, or if another user attempted to access the same record; it would retain any edits in a temporary file to ensure they were only committed to the main database after that backup/synchronisation process had been completed, which then helps to prevent data conflict/corruption. RootsMagic, in common with many other genealogy programs, uses an SQLite database model that is not designed or intended to work in that way. That's a downside to SQLite that is far outweighed by the upside of being entirely free for developers to use in their desktop software, which keeps (should keep) costs down for both the developer and end user.
Cloud services will, when correctly designed, often lock individual files during the backup/transmission process, but that of course can easily lead to the local user believing that their system/application has 'locked up' without warning, especially if a considerable amount of data needs to be synchronised, or if the internet connection is slow, which is why the recommended action is to suspend Cloud Backup services while using files that are being constantly written to.
If I remember correctly, Gramps does not currently use a traditional Database model, but stores its data in an XML File, i.e. a special form of text file which would suffer in the same way as any other text file if you tried to edit it and copy it at the same time.