The trouble with coupling the two is that now I have to either trust some third party db service, or some custom db.
The DB is so fundamental, and so hard to get right / scale, that it's hard to trust a startup to do it well.
We use Firebase and even with all the resources google has this has a lot of issues (especially with the client libs).
https://electric-sql.com/
I'm not convinced that separating the two tools is best for usability, loose coupling sure. But some level of integration enables the reactive front end querying to swap between the front end copy and central source depending on if you have the data copied locally.
Also many of the thing need for reactive re-querying are also needed for two way syncing.