Obsidian, Zettlr, and Logseq live in the category of local plain-text file-based PKMs.
Trilium lives in the category of local database-based PKMs.
The reason the first category exists is that people wanted to get out of vendor and file lock-in.
Apples and oranges.
Having been through the enshitification of Obsidian, it was important to me and many others to be not beholden to any vendor's file system. Your database requires Trilium to be instantly usable. My notes are useful and usable (and frequently accessed) from Logseq and VSCode.
The two options are simply not comparable, hence apples and oranges.
I really appreciate you posting this. I'm a long-time Obsidian user, and an Evernote user before that, and I never "got" Logseq. I just couldn't understand what people saw in an app that didn't let you "write" anything. I've tried to start using Logseq so many times and just given up because the interface made no sense.
Thanks to your comment I finally get it! I prefer to be using something open-source, so I'm going to give Logseq another go, now that I finally understand it, and see how that approach feels.