Glam metal rocker announced he was diagnosed with Lewy body dementia and multiple system atrophy just last month