I used to think sata was great (the chunks knocked out of my fingers by removing molex certainly did), then I discovered M.2 and now my opinion: die sata, just die, with your annoying fragile connectors and stupid cables. But, until there's 3 or 4 m.2 slots available on a board (and enough lanes for them to actually work properly: looking at you B660/H610), I can't see sata being replaced entirely. So, an upgrade taking them closer to PCI-E drives in performance would be pretty nice.
My understanding is that it still wouldn't be compatible with DirectStorage, something about the protocol and overheads being higher, or more complex with sata? Idk exactly what the details are.