The frontman from the Mötley Crüe has opened up about his horrific health ordeal he suffered earlier in the year