The entire album (Nightfall in Middle-Earth) is about the Silmarillion by J.R.R. Tolkien, a book of legends set long before the events of The Lord of the Rings.
This particular song seems to be about Turin Turambar, son of a great mortal hero, who was driven to madness and death by his destiny.
Turin was haunted by cruel fate. While he was a great hero in his way, he also brought grief and death with him wherever he went...for example, when an elven friend of his -Beleg the Strongbow- found him having a nightmare and tried to wake him, he believed his friend to be an enemy, attacked and killed him, with Beleg's own sword. His mother and sister, who he had been searching for throughout his entire life, were driven to madness and suicide by his actions even though they never actually met. He was responsible for the fall of an entire elven kingdom, and so on.
In the end, Turin defeated Glaurung, the oldest and greatest of Morgoth's dragons. After this, his insanity passed, and he saw for the first time all the things he had done.
In pain, he threw himself onto his sword, the same sword he had taken from the corpse of his best friend Beleg and so ended his life.
Not really about Drizzt.
The entire album (Nightfall in Middle-Earth) is about the Silmarillion by J.R.R. Tolkien, a book of legends set long before the events of The Lord of the Rings. This particular song seems to be about Turin Turambar, son of a great mortal hero, who was driven to madness and death by his destiny. Turin was haunted by cruel fate. While he was a great hero in his way, he also brought grief and death with him wherever he went...for example, when an elven friend of his -Beleg the Strongbow- found him having a nightmare and tried to wake him, he believed his friend to be an enemy, attacked and killed him, with Beleg's own sword. His mother and sister, who he had been searching for throughout his entire life, were driven to madness and suicide by his actions even though they never actually met. He was responsible for the fall of an entire elven kingdom, and so on. In the end, Turin defeated Glaurung, the oldest and greatest of Morgoth's dragons. After this, his insanity passed, and he saw for the first time all the things he had done. In pain, he threw himself onto his sword, the same sword he had taken from the corpse of his best friend Beleg and so ended his life.
So...great song about a great tragic hero.