The Black Sabbath frontman admitted he was done his on stage persona and wanted to put his grandkids first and didn't want to 'die in a hotel room somewhere'