I don't think it's a compensation mechanism. For some maybe.
But a lot of people had tons of money and got rid of them to be poor(er) and win some kind of freedom or normalcy that was important for them. Some did it directly, some did it through drugs, alcohol and extreme spending that showed that they didn't value the money at all.
I know a couple of people from rich families that ended up as austere monks, living in a monastery in my country. And people like Witgenstein (huge fortune, left it behind), Burroughs (of the "adding machine" family), etc.