It terms of actual numbers, that's a big unknown. Nobody knows exactly how much the Vita sold. Estimates are in the 10-15 million range, so it was somewhat close. They were both failures, though. But while Nintendo took another stab at the general idea of "You can natively play on TV or in handheld mode" and eventually landed on the idea of a "hybrid" system, which became the very successful Switch, Sony completely abandoned handhelds after the Vita and did not create an immediate successor, and probably considered the PSP a fluke (which it kinda was, as it was the only non-Nintendo handheld to ever be a huge success). I'd consider it a "strategic victory" (for lack of a better phrase) for Nintendo since they kept going and learned from their mistakes while Sony just gave up and focused entirely on home consoles instead of immediately trying for another handheld.
To be fair to Sony, though, they did eventually make the PS Portal for the PS5, which is conceptually similar to the Wii U controller (and as of the end of 2025 it had a 7% attach rate to the PS5 in the U.S. according to NPD/Circana, which isn't bad for a $200 optional accessory), and according to the rumor mill the PS6 will have a Switch-like "hybrid" SKU, which if true means they'll have a "kinda-but-not-officially-but-technically-yes" handheld that can be docked for TV play. So, they do understand that having handheld play of some kind is still something popular and viable, even if a "traditional" handheld doesn't appear to be in the cards. In fact, the only "traditional" handheld we've had from anybody since the 3DS/Vita era was the Switch Lite, which is only 17% of the Switch's LTD sales, or about a third of what the 3DS sold, so most people really do want their handhelds to be able to connect to the TV these days.
Visit http://shadowofthevoid.wordpress.com
Art by Hunter B
In accordance to the VGC forum rules, §8.5, I hereby exercise my right to demand to be left alone regarding the subject of the effects of the pandemic on video game sales (i.e., "COVID bump").