Yes, there will be at most 3 voting database nodes.
If you shut down node 3 (lxd03) gracefully (e.g. with lxd shutdown or systemctl stop snap.lxd.daemon) then node 4 (lxd04) will automatically become a database node and node 3 will step back to be a non-database node.
I checked the DB take over you said.
Also, it was confirmed that even if lxd03 survives, the DB does not move back from lxd04 to lxd03.
When there are 10 nodes in the lxd cluster, when the node having the DB shuts down normally, is it possible for the user to specify the node that the db takes over?