That's just as much failure of everybody as it is of him. This was dementia speaking and society needs to learn that.
You wouldn't tell somebody with a broken leg to get it together and it's just their personality that they can't walk. Nor should you treat dementia like that. Yes, people seem to shift personalities and anger others. But those others need to understand that it's a medical condition, an untreatable and fatal one, so should have even more sympathy than with somebody who broke a leg (cause that will likely just be temporary). Not alienate the person and speak ill of them.