I got a sample on my desk and havent found a reason to use it.
1) In addition to SWD/JTAG, I use a debug serial port as well. Solving half of the problem is not enough.
2) I have no problems soldering my own SMD 1.27mm/2.0mm headers on my development boards. In schematics, these are set as no-load and only devel boards get them soldered on.
3) Too flimsy to use for manufacturing
4) Most of the modern microcontrollers and application processors have built-in bootloaders. In most cases, it can be arranged, that an already present external port (mostly USB, sometimes serial or others) can be used for programming in manufacturing, if it's a small run and constructing test jig is not justified. For larger runs, the test jig handles connections.
I've been keeping my eyes open for no-solder debug connectors. So far, incorporating a card edge connector would make the most sense, but it does not have large enough advantage to start using it and create additional adapters and cables. For now, I've used the same serial port footprint for over 10 years and a big number of boards; the same JTAG for all Cortex-M projects and so on. Keeping things uniform is a good thing as well.