A rockstar was sadly diagnosed with stage four cancer while in the middle of recording his comeback album after almost a decade away from his passion