If editors own memory usage is your main concern then you should use emacs or even better mg or vi.
The editor + its plugins + it's LSP server is what counts. I dont care if zed is written in rust and uses 400MB when it spawns a multi GB nodejs process when I work on my tiny golang project.