The correct option is (D) much.
The news about the retirement of my favourite character gave me much disappointment.
"Disappointment" is an uncountable noun. For uncountable nouns, we use much (not many or few, which are for countable nouns). Little means "almost no," which changes the meaning entirely. Much correctly quantifies the degree of disappointment felt.