Rod Stewart was diagnosed with a malignant growth on his thyroid gland after a routine health check, which left the rockstar feeling 'fearful' and 'vulnerable'