The only potential advantage I see would be read and write speed, but aren't SSD's already fast enough to saturate the SATA bus ? Isn't that why NVME offers better performance than SATA ?
What is clear is that for equivalent capacity DRAM is much more expensive than an SSD.
My guess is that if no one is making a product like what you are asking about it's because it offers no real advantage over the much cheaper solution of adding another SSD.