Black Sabbath frontman Ozzy Osbourne shared his honest thoughts about whether there might be life after death in a poignant memoir set to be released posthumously