I only had the Stone Hearted LTR once and it was quite a while ago. I do remember that the Sim didn't mourn when her husband died. I don't remember whether or not the Oh my ghost opportunity came along - it was during my Dynasty, and I couldn't use the opp anyway. But I would think that if there's been a recent death in the household and you have the remains, you should get the opportunity.