I think that in most circumstances, they'd mind a lot. I know I would mind, if somebody brought the firefighters that died in 9/11 back from the grave, as rotting skeletal things. I'm pretty sure my dad would mind, if his best friend who died in Vietnam got brought back from the grave as a flesh eating zombie.
There might be a few cases where a dwarf hero risen from the dead was accepted and welcome into your fortress, but I can't see it being a common thing at all-dwarfs seem to very much sanctify their dead, and they've got quite a lot of thematic impetus towards honoring heroes, last stands, heroic death, and peace in the afterlife.
Mostly, a revered dwarf that's gone to his final resting place, is going to be honored, with rest.
Besides, even if necromancers are nobles with high positions in the fortress, they're still nobles, and they're still necromancers, neither of which designation is nearly as likely to impress a given dwarf as a hero that worked and sacrificed their whole life in defending the fortress, including that dwarf's home, children, and livelihood.
And it wouldn't just be 1 dwarf taking up arms against the necromancer and his unholy abomination, it'd be all of them, every single one, down to the kids, so even if your skeletal axelord won...well, your vacant fortress would make a nice adventure-mode destination.
Maybe, very rarely, a fallen champion might be brought back to guard something that was incredibly important to the dwarf species as a whole, but that would require a bit more background than a necromancer's whim.