No, its biggest problem is that it's outrageously expensive. At its core it's a four year old console selling for significantly more than release price.
Here are Playstation release prices adjusted for inflation and rounded:
PS4 $540
PS4 Pro $520
PS5 Digital $490
PS5 Pro $700
A similar relative price point to the PS4 Pro would have seen the PS5 Pro release for $470; and at that price it would likely have been popular, even without any really meaningful upgrades.
Yes, but since the pro doesn't have a disc reader it's more comparable to the Digital.
It also doesn't matter, when compared to the standard model the Pro is still a shit deal as it released for 500$. (And came with a disc reader and a vertical stand, which are over 100$ extra for the Pro.)