Heavy metal legend opened up about his ongoing health issues as he prepares to take his final bow at a massive show in his hometown of Birmingham this summer