From the beginning, there were concerns about this push towards 1-bit systems into the consumer space along with claims that 1-bit PDM should form some kind of archival foundation for music. There were critics include Lipshitz and Vanderkooy - see their paper "Why Professional 1-Bit Sigma-Delta Conversion is a Bad Idea" from the September 2000 AES. And the next year in May 2001, they followed up with "Why 1-Bit Sigma-Delta Conversion is Unsuitable for High-Quality Applications". Even Bob Stuart chimed in on the unsuitability of DSD for "high-resolution audio" back in 2004. This is no surprise since Meridian was firmly with DVD-A including developing the MLP compression system which subsequently has been licensed by Dolby and renamed TrueHD; it looks like Dolby and Meridian had an arrangement dating back even to 1998.
These concerns around fidelity and the unsuitability of 1-bit PDM as an editable format in audio production are why in the professional world, we see audio recorded and edited in 24/352.8 "DXD" and Sony's own "DSD-Wide" (8-bit/2.8MHz) instead of DSD64/1-bit "DSD-Narrow".
While this was playing out in the academic/professional arena, the advertising industry including the "mainstream audiophile media" championed DSD and published all kinds of flowery words suggesting how it sounded "more natural", or "analogue-like" compared to PCM. While I don't think we can put an exact date on when DVD-Audio officially died as a viable commercial product, I think by 2005 it was quite clear that hi-res physical formats were not going to be mainstream and DVD-A did not have the number of titles available compared to SACD. My sense is that the hybrid-SACD feature with both DSD and CD-compatible layers was a major differentiating factor that has resulted in still a trickle of SACDs released these days.
I'm bring this stuff up now as an extension to the discussions around SoX-DSD and the Philips Test SACD articles last year during my series on the Topping D90SE review because I've been thinking about how best to standardize the DSD test signals I use when testing. Different DACs tend to handle DSD playback differently and I wanted to make sure that my test signal parameters are at least somewhat in line with the music encoded on an SACD or maybe DSD128 download these days.

