Elon Musk acknowledges mission failure, posting on X that 'success is uncertain, but entertainment is guaranteed'.