Joel Hoekstra remembers "one of the all-time greats of hard rock and heavy metal" backstage at VH1's That Metal Show