Grammy and Oscar-winning musician shared honest footage of the struggles he went through while recording his new album