The legendary Prince of Darkness had last performed live in a surprise appearance at the closing ceremony of the 2022 Commonwealth Games - with a bracket for support