Step 1. Install Tabs plugin. You might want to search for it inside the Plugins marketplace in Logseq app.
Step 2. Get rid of annoying Cmd+W shortcut that is useless in Logseq in MacOS settings:
Settings: Keyboard > App Shortcuts > Keyboard Shortcuts… > App Shortcuts. Bind “Close Window” to cmd-shift-w or anything else.

Step 3. In Logseq go to Settings > General > Keyboard Shortcuts > Plugins and set shortcuts like this:

Now you can move between open tabs with cmd+option+➡️ and cmd+option+⬅️ and close current tab with habitual cmd+w.
Solution found here:
https://github.com/logseq/logseq/issues/3967#issuecomment-1583378343
If you have found this post useful, please consider supporting my work with a donation on buymeacoffee.com/99rabbits. Half of the proceeds go to the Foundation "Come Back Alive", supporting Ukrainians.