> This has always been my problem with adopting Emacs or Obsidian

That's an orthogonal problem. It's almost trivial to set up Org-mode so all your personal notes are always encrypted on disk.