Yes. I use Emacs for Org mode only.
I have tried using Emacs for other purposes, such as writing code. Ultimately I gave up and went back to Vim.
I have also tried other task management systems (you can do a lot with Org mode, but I use it only to keep notes and to-do lists). Org mode is far superior to the other systems I have tried or otherwise considered.
I think of Emacs as a a programming environment. By itself it’s not useful. It needs applications to make it useful. Org mode is one of those applications. Some programming languages have good Emacs modes so Emacs might be worth using to write code in those languages (I program mostly in Haskell, and the Emacs modes for it leave a lot to be desired, so it’s easier to just use Vim.)
The old jokes about Emacs just needing a good text editor really are true. If someone has programmed Emacs to do what you need, or if you’re willing to do it yourself, Emacs works well. If you don’t want to program your editor, don’t use Emacs. Org mode is so good at what it does that I keep an old Linux Thinkpad around just to use it, though I can use it on my Macs as well.
Though I’ve heard of Org roam, I’m not sure what it would add to my workflow so I haven’t used it.