Used in such a context, I would reserve the adjective ‘tragic’ for the fall of great men. Weiner was never a great man. Try tawdry or humiliating.
I only post the CNN view for the sarcasm opportunities.