So, there a lot to say here:
First of all, it's true that there isn't that much graph/comparison of memory usage/or which DE(or Desktop Environment) are the smallest in term of footprint(as the other demonstrated).
That doesn't mean that there can't be one right? the only way to truly know (since most of those comparison or review aren't always updated, contrary to the codebase of the aforementioned subject) is to try it yourself.
It sounds easier and faster than other may think, given on how most of the distro have the tendency to let users run into a live session, which is either kept in a ram drive or ram directly.
I wouldn't recommend doing this, neither to distros (though you don't need to change distro to try different DE) or the DE themselves. As most will tell you, "distro hopping" is bad practice (though most users, me included still ended up doing it anyway)
What's important is, what you want in a DE? if it's only low memory usage, while keeping all of it's core usability, then why not use a windows manager or WM for short? While the name isn't describing it's real potential, WM can and do (for most) support most of what a DE does.(without using as much ram)