He found fame and fortune on British TV — but his real life was devastated by family tragedy and financial ruin before his death in 2007