This is scary as hell, being rich and later dieing poor with nothing to leave behind for heirs and even charity. It would have been better they were poor but later because rich before death so dependants won't suffer. This is indeed a good motivation for us to take our finances seriously and plan for the future smartly.
And how many such famous people have there been throughout history? A huge number. So what? Well, man is not given the ability to manage money properly. What's wrong with that? But he has another talent, to which he has dedicated his entire life.
Knowing how to earn and save money is also a kind of talent. Not many replaceable and outstanding personalities have it. Everyone has their place in this life.
The scary part, is getting used to a better life and then losing all of it. Obviously that is normal and we got used to it by now, but we need to realize that doesn't make it any less painful. I always give the same example, a parent dying before their child is normal, it would be a horror when a child dies before the parent, but even when the parent dies first, which is the natural part, and majority of the humanity since existence, we can't really say it's not painful.
Just because something is normal, doesn't mean it can't be painful. We just have to face the fact that if you got rich and then lost all your money, then it doesn't mean you are going to lose all your money, it's going to be hard to go back to a poor life.