Bring it up in the Trope Repair Shop forum.

It refers to the Fred from "Sanford and Son" who would always fake having a heart attack to get out from under pressure of any sort. Naturally, Redd Foxx (the actor) died of a heart attack in real life later, making all those scenes very ironic. Worse, because of his role, no one believed it was a real attack initially, which may have sealed his fate.

I think we also need an explanation for Rock Hudson, Woody and Mia, and Taylor and Burton or to cut them out. I got the Woody and Mia real life drama, but I've never seen "Husbands and Wives" to properly explain the contrast, and I didn't recognize the other three. (Some reading of The Other Wiki helps with the other three, which are all pretty dated references, but I'm not sure how these are examples of being unfunny in retrospect as opposed to just having ironic contrast. At least Woody Allen's movie was a comedy.)

Slightly less work: sort all examples by type and create Type I and Type II sections in each subpage.

No. A Funny Aneurysm Moment has to happen before the event that makes it cringeworthy. This was someone making a joke directly about the earthquake and tsunami.

That's just Dude Not Funny.

A Funny Aneurysm Moment is one that's meant to be funny at the time, a better example would be a tsunami in a cartoon headed for Japan from the 90s. Dude Not Funny is when someone plays something for laughs that shouldn't be, this one was about the earthquake after the fact, not a joke about something like it beforehand.