“Demise and Rise” is a brutally honest documentary about Steve-O’s decent into madness, and how an intervention saved his life.