I think that in the stories Watson mentioned it being slow? So I had always had the impression of something more like cancer or TB.
But no, double-checking on that, I don’t think ACD ever said even that much about it. It’s only known that she died, sometime between “The Final Problem” and “The Adventure of the Empty House.”
But John being left with bebe twins and Sherlock would be awfully interesting!