While many had feared that Ozzy's family would be offended by the video, after its release, the late star's official account reposted a tribute shared by Rod on July 22