I think Alzheimer's is scary because it's not just about intelligence. If it was just that you become dumb(er), I wouldn't mind it that much. I must be an exception, but beyond a certain threshold (I wouldn't want to be drooling idiot) I'm not that attached to my intelligence. I'm painfully aware that I'm average and that I had the luck of having an education and a stable home that other, more intelligent but less fortunate people than me, didn't.
I think Alzheimer's is scary because your whole personality goes. Cognitive functions. Memory. You stop being independent. You cannot do the simplest things by yourself. Things become scary and you're not sure why. You are alone, surrounded by strangers.
If there was a progressive illness where you got less intelligent, but still able to function and tell who your loved ones are, remember things, and at least understand where you are and your new place in the world, to me it wouldn't be half as scary as Alzheimer's.