Sir Brian May is heartbroken following the death of one of his loved ones and has described the loss as one of the "worst" days of his life.