PS5 Pro is just trying to entice the PS4 laggards to upgade, just as the new XBOX SX models are for XB1 holdouts and maybe the odd SS upgrader. Neither is going to attract platform switchers or console newcomers.
The fun question is what happens when the next XBOX shows up in 2026?
Will Sony replace the Pro with the PS6 in two years?
And yes, $800 (with base and disk) is very much in midrange gaming PC territory or even a bit higher than DIYers. (Off course the EU price is closer to $900 but they'll buy it happily. Brand loyalty rules there.)
Now, a devil's advocate would point out the PS3 launched at $499/$599 in 2006 dollars which after 18 years of inflation comes out to $800-950 and still the faithful bought it. So Sony can charge them the equivalent of US$1000, with base and drive: $900 without, and it'll still sell. They're loyal to a fault.