I think the question you should be asking is "who is the Scorpio's target consumer"
The Pro illustrated a decent subgroup of people looking for a little more horsepower for their 4K TV or, even more niche, their PSVR. That is talking into account the large playerbase the PS4 currently has thanks to strong launch and now extremely strong exclusive software. The Pro was never meant to be the "next big thing" or the "new Playstation" and even Andy House blatantly said it was basically just to keep enthusiasts from jumping to PC after the halfway point in the gen. There wasn't anything riding on PS4 Pro, it was basically locking down enthusiasts.
Scorpio has a much different set of circumstances to contend with. Xbox won't have any true exclusives going forward, and on top of that the first party situation is pretty dire presently. It doesn't have the huge install base, so if say the same % of people who upgraded from the PS4 to Pro upgraded from XB1 to Scorpio, it will still be much less. And MS still has to convince people the graphics upgrade is massive enough for the price tag, while also dealing with people that already have decent PCs having no reason whatsoever to buy a Scorpio (while at the same time reassuring people that the XB1S they just bought last year won't be worthless in 12 months)
It's a tough road ahead for MS, but I think they have a good shot to at least turn around brand perception, even though they won't close the hardware gap this gen.