Well, it was bound to happen sooner or later, even if he is a little author's pet.
Hey, at least he's in a blaze of glory..y'know, with underlings never mentioned in novels, doin' all the unimportant things.
Well, from a bad writer's perspective....Elminster went to Hell, and now Drizzit is in the Abyss! He must kick some ass and escape! With two scimitars! Woosh!
From a DM's perspective...he's a hero in the world...what happens when heroes die?
-The lesser heroes run around looking for a way to revive him
-Any evil organizations that he put in check unleash themselves upon the world as soon as possible
-The bigger heroes instantly get interested, as one of their own has fallen. They do what is in their power to help him.
So this could complicate things, somewhat. The baddies could actually have an edge for a while, here, especially if the body was eaten/destroyed, and if they were already prepared to almost unleash their next Big Trouble on the world. Death probably wouldn't be permanent, unless they can somehow make the spirit of Drizzie imprisoned/unwilling to leave the home plane. They could grab the body and then store it somewhere, so that powerful resurrections don't work (the body's still intact), and that the lesser resurrections make him appear back in his body, in the stronghold of the enemy...mwahaha...
I would say it's a good chance for the PC's to step up and fill his shoes, while the other heroes run around trying to fix the mess so that these amatures don't mess things up any more.
And I would also say that this is probably one of the worst things that could happen. The last thing a broody hero needs is a brush with death...can you imagine how pathetic he's going to be when he gets back?
Ugh. It hurts to think about.