I sync two databases across Mac, linux, ipads, and android phones. One for work, one for personal.
I mean you can only run into a problems when you change it in two devices without sync in between. But that is super unlikely (in general; if you have reliable internet; you can improve reliably of this setup by syncing to a kind of server/file storage as "source of truth" as it won't be e.g. out of battery or disconnected from the internet ;-) ).
And as long as what you use for syncing doesn't blindly overrides when conflicting syncs happen you can resolve the problem by hand, not that I would expect it to happen. (At least with KeePassXC this works well, I haven't use keepass as most places strongly recommend XC over keepass without XC.)
you can improve fool proving by watching the db file for change and then uploading it
you can further improve it by checking if the uploaded file is the one which was there when you did download it last and only then upload your changed version
but yes, for many people that simple approach would be good enough by far I mean how often do you add new passwords?