Pujols may have been on a decline for the past few seasons, but you cannot argue he isn't a future hall of famer. He mashed the ball for a decade with the Cards, but everyone (and I mean everyone) knew he would not be worth the money in the final years of this deal. Another thing to keep in mind, he was very respected in the game. He played the "right" way, and did a ton of community work. By all accounts, he was an amazing teammate and a good person.
So, for him to be unceremoniously DFA'd and cut, it upsets some people. That being said, I think the Angel's did what was best for the team. They have a guy who is better than Pujols, and they could use the roster spot for someone who can contribute more to the team.
Whenever you sign a dude to a 10 year deal at 28 or so, you can almost guarantee they won't be worthy the money by the end.
EDIT: Also, I agree with you, I can't see him signing with any team. Maybe a one-day contract with the Cards so he can retire with them. But to say he sucked for the entire 10 years in California is untrue. Hell, even in 2019 he got over 100 RBIs. He was a solid producer, not Cards level, but still pretty damn good.