Irish rocker Vivian Campbell said the transplant was his "only hope to survive"