Definitely not worth dying to see since there's mass graves there from the cities "unclaimed souls". That's most likely where the rotting smell comes from.
While it does have a beautiful view of Long Island Sound and Eastchester Bay, the decor is dreadful, not to mention it smells of something rotting. My two cents, it ain't worth dying to see.