The story of The Beach Boys' co-founder Dennis Wilson is a sad one, and not altogether rare for 1960s and 1970s rock stars.