Tragic death? Yes, indeed! His actions seem to indicate a non-saved person. If he was not saved (only God knows) and died in that state, it was indeed tragic.
I think Phelps really was an atheist, who used his “Church” to give Christians and anti-sodomites a black eye....and the media cooperated with him in this farce.