Hollywood star Dwayne 'The Rock' Johnson has told fans he's been left "numb" following the death of his beloved family member