I'm one of the people who started using emacs just for org-mode about a year ago. I've been using it daily to manage my schedule, TODOs and projects. It's nice, but IMO overhyped by a very vocal religious minority. I've been spending as much time configuring little things and working around rough edge cases than it has actually saves me. Elisp is still somewhat of a mystery to me and I'm mostly copying and pasting snippets without truly understanding what's going on.

I've encountered so many little issues that resulted in hours of debugging and searching for solutions that the net productivity gain has definitely been negative. True, if I stick with it for 10+ more years, the productivity gain will likely become net positive, but who knows if that will happen. IMO it's quite likely that better systems are going to be invented over the next 1-2 decades. It's clearly outdated.

Only do it if you are willing to invest a large amount of time into learning emacs, and if you are planning to stick with it for decades. The best for me way to describe it is: Emacs is the ultimate procrastination tool. It's great at making you feel productive by letting you do meta things with elisp and configs, when you really should just be getting stuff done.