Its fairly difficult to find “up-to-date” performance / RAM comparisons of Linux Desktop environments, but here’s a decent one from 2019 comparing memory usage of different Ubuntu flavors.
The most surprising thing is that despite KDE Plasma’s reputation as being more ram-hungry, it actually used less ram than XFCE, meaning its developers have been making performance a focus.