The Black Sabbath legend was suffering from Parkinson's disease since 2003 and had undergone seven surgeries in the past five years, including a fourth spinal surgery in September 2023