Not for me. Apple Mail used 155 MB RAM for all processes with 3 Accounts connected. Mailspring used 366 MB for all processes with only one of the 3 Accounts connected. The Mailspring Helper (GPU) alone uses 130 MB RAM …
Both had the same mail opened.
I'm using macOS 14.7.3, not 15. Don't know about Apple Mail in macOS 15.