It's a bit reductive to call it "the editor for VBA macros", it's like calling Visual Studio a "template editor" because you get a set of template files when you create a new project.
The purpose of VBE is to build applications, it's an IDE. Add-ins like Rubberduck are actually very useful in extending the capabilities of VBE and there are still millions of people using VBA every day to solve business problems.