Money does not = happyness no matter how much you "think" it will, IMO. Especially when you have as much as he did. You look for other things.
BUT .....
I couldn't see why he would not have been happy in the situation he was in. He had a wife and son. A very well paying job. Who knows ... it's so sad to even think about it.
I watched him growing up. When I was into the entertainment type wrestling, he was my favorite wrestler, no joke. I remember when he was with the 4 horsemen! I also remember watching his wife when I was younger.
From the sounds of everything, he probably did do it.

What a shame. My prayers go out to the family & friends.