Why is Goodman’s dying hour gloom, as the final line of the story tells us? Why should his dying hour be so filled with despair and devoid of hope?

After Goodman Brown awakes in the forest alone he can not tell if what he experienced in the wood with his wife, Faith, and the devil was real or a dream.  No matter which it was he becomes suspicious of everyone.  He can no longer go to church and listen to the hymns the same way.  He had discovered that night that everyone is suseptible to sin and everyone falls.  He begins to treat everyone differently and he has lost his love and his "faith."  Because of what happened that night in the woods, he experiences a terrible and gloomy life.  So suspicious and angry that when he dies Hawthorn writes:

"And when he had lived long, and was borne to his grave, a hoary corpse, followed by Faith, an aged woman, and children and grand-children, a goodly procession, besides neighbors, not a few, they carved no hopeful verse upon his tombstone; for his dying hour was gloom."

There is a lot more great information about this story at the following links.