"To be able to shove 1TB of Optane into a memory slot and allocate 32GB of that to system RAM"
I'm not sure that would help. Optane is still much slower than DRAM. Using 32 GB of Optane instead of 32 GB of DRAM will just lower your performance.
The benefit of Optane-as-RAM is that the storage capacity is so much higher. Optane allows datacenters and workstations to have terabytes of what is effectively slow RAM. If you've got a several-terabyte database, then having mere GB of DRAM forces you to keep swapping out portions of the database between RAM and storage. Having TB of Optane as RAM would allow you to keep the entire database in RAM. Even though Optane is slower than DRAM, the benefit of keeping your entire TB database in RAM would more than make up for it.
But if you've got only 32 GB of RAM, then switching to Optane wouldn't benefit you.