I only tried once about 15 years ago (from GUI IDEs/editors) and it didn't appeal to me. Now with GitHub Copilot and the like I think the use of command-line editors will further diminish for generalized programming tasks, although they will always have a place in system administration.
Realistically, there’s not much emacs can’t do, including integrating with copilot[1]. I think it’s niche isn’t system administration, but people who have the time, energy, and interest to really invest in their tools. Its configurability is second to none, and it’s not going anywhere. Emacs will still be around long after vscode is forgotten, and it’s nice to know that the time I spend learning my editor won’t go to waste when some big corp decides to up and leave, or the programming zeitgeist moves on to the shiny new thing.