Sir Rod Stewart has broken his silence with a gut-wrenching confession about the toll fame has taken behind closed doors.