That is a great idea. I think the software is going to be the hard part. You would need some kind of heuristic or software to manage moving memory between those two locations. That is just my initial thought I could be totally wrong.
I really like OSTEP's chapters on virtual memory if you're interested in reading more[1].
Relatedly, I've heard of using Intel Optane as "slow RAM" for cold pages, and I think the idea there is also that it'd be in one or the other but not both. (Optane can be thought of as very expensive/fast flash or very slow/cheap RAM.)
See also Linux cpusets (cset command), which can be used to control which NUMA nodes a process has access to.
You'd be surprised how many modern OSes are at least partially NUMA aware. Even Java already has a non-uniform aware allocator.