Pretty sure PS3 lost Sony more money than the Wii U lost Nintendo (somebody correct me if I'm wrong). But PS3 ended up selling a lot of software, a respectful number of consoles, and is highly acclaimed by many.
Wii U on the other hand sold even a good deal less than GameCube, and very far below Wii. Nintendo is mostly ashamed of Wii U, and when many Wii U games have been ported to Switch Nintendo is hesitant to even mention Wii U.
Switch is the bigger comeback story.
Lifetime Sales Predictions
Switch: 161 million (was 73 million, then 96 million, then 113 million, then 125 million, then 144 million, then 151 million, then 156 million)
PS5: 115 million (was 105 million) Xbox Series S/X: 48 million (was 60 million, then 67 million, then 57 million)
PS4: 120 mil (was 100 then 130 million, then 122 million) Xbox One: 51 mil (was 50 then 55 mil)
3DS: 75.5 mil (was 73, then 77 million)
"Let go your earthly tether, enter the void, empty and become wind." - Guru Laghima