What is the tragedy of young goodman brown? and which scenes is it in?

I think the tragedy could also be the very ending of the work where the narrator states:

"Had Goodman Brown fallen asleep in the forest and only dreamed a wild dream of a witch-meeting?

Be it so if you will; but, alas! it was a dream of evil omen for young Goodman Brown....when he had lived long, and was borne to his grave a hoary corpse, followed by Faith, an aged woman, and children and grandchildren, a goodly procession, besides neighbors not a few, they carved no hopeful verse upon his tombstone, for his dying hour was gloom."

The tragedy is that Young Goodman Brown let all of this control him and it ruined his life.  His faith was placed in man, and when man failed him (as man always will because we are human) he despaired for the rest of his life.