How is the ending of The Great Gatsby tragic?

He dies. He is the main character of the book! He was a high status man who became social royalty for a woman who didn't even value him. His funeral was desolate. Every single one of his so called "friends" did not attend. It's tragic because everything Gatsby worked for ended in shambles. It represented nothing.