Okay quick question. What is the intended market for NVMe connectors? Another question. What is the market for SATA-Express? Okay final question at what point do you expect to be able to purchase a Dell Desktop and have it support M.2 out of the box? Sorry one more... What is the ratio of SATA-Express support to M.2 support on retail motherboards?
Doesn't matter if there are no SATAExpress (I'll just refer to it as SATAE to save typing) drives available. You
can buy M.2 drives, and both SATA and PCIe ones at that.
Whether M.2 takes off in common pre-builts is a valid question, its actually being actively used in higher-end workstations. We'll likely just have to wait and see what happens.
NVMe was a standard developed for Laptop/Tablet/Ultrabook developers to agree on one standard connector for SSD's that would be faster than SATA-3 and be flexible to work in several form factors and situations. What it wasn't developed for was to be a desktop computer solution to remove the use of 2.5 drives in desktops. It's why until today there is not a retail M.2 drive solution. Why sell a retail version of a drive that only works in .1% of new computers built this year, let alone the .000001% currently in use systems that supports it.
I think you're confusing a few things here. SATA and NVMe are drive interface protocols, it doesn't matter which physical interface that protocol is used over. An older example would be SCSI. The physical SCSI interface is long dead, but the protocol used is still very much in use (enterprise SAS). SATA itself is just plain old IDE running over a serial back-end interface, instead of the older parallel one.
M.2 is just the physical interface/connector used. Which protocol used over it doesn't matter. That's why you see both SATA and PCIe drives using the (almost) same connector (different keying). PCIe is just the bus linking the SATA/NVMe controller to the CPU. Nothing more, and nothing less.
As for availability, SATA M.2 drives have been available retail for ~2 years. You have also been able to buy PCIe based M.2 drives at retail for 2 years (Plextor M6e).
You're right about PCIe drive compatibility, but that's because the popular Samsung XP941 and SM951 weren't meant to be available at retail. They actually use the SATA command set, but lack bootable OROMs. Some mainboard OEMs chose to add boot support on their own hook and semi-officially. If your mainboard doesn't support those drives, you can buy a Kingston HyperX Predator. Which will boot on pretty much any mainboard with PCIe connector that can fit either it or the included PCIe-to-M.2 adaptor.
NVMe support is still a bit spotty, most H/Z97 and all new Skylake (LGA-1151) boards have it, but not anything older.
I can't answer why SATA-express hasn't had any traction. If anything it's probably just waiting till the next release cycle because they weren't ready to have two different 2.5 controller and connector solutions. But if you PCI-Express to succeed on the desktop. You want to see SATA-Express get more adopted. Without express based SSD's will be limited to Mini-ITX mobo's and a few uber niche solutions (like Asrock).
Perhaps because developing SATAE controllers took longer then expected. In the meantime, those who needed something faster-then-SATA3-can-handle, used the only thing available at that time. The Samsung XP941, which only came in M.2 flavor, because of its laptop origins.
The physical design of the SATAE connector doesn't help either. Only PCIe 2.0 x2 (which is barely faster then SATA3) and brings back unpleasant memories of ribbon cables... D: