Just weeks before his death, the legendary ‘prince of darkness’ was celebrated in a final hometown gig that raised £140m for charity