On Wednesday, the 60-year-old Grammy winner shared a video of himself playing guitar and revealed he developed leptomeningeal disease, a complication where cancer cells spread to the leptomeninges covering the brain and spinal cord