I can confirm that this works beautifully with Paperpile, even with a database of nearly 6000 citations. I have Paperpile set to auto-update the BibTex file to Google Drive, which is synced to my desktop. I then use Hazel to copy that file to my logseq assets folder whenever it detects that the file has been modified, replacing the original file. (The plugin could probably just be given the path to the original file in Google Drive, but this way it could also potentially work on a mobile device, even though I haven’t tested that yet.) Unfortunately the Paperpile bibtex doesn’t include all one’s notes and annotations, so one would have to manually add those to the note separately. That is fine for me, since I usually pull these in via Readwise anyway…
None of this is ideal, but at least there is some way to pull your metadata from either Zotero or Paperpile into Logseq without too much friction…