Yes, I generally try to avoid it too. But sometimes it looks good if you are looking for a "vintage" aesthetic or, as in this case, to mask a major defect and try to save the image...
I agree that the added grain does not work in this case. Not necessarily the grain, per se, but the particular grain you added -- looks fake. So maybe a different added grain would work, or a lighter touch of the applied grain. That said, I think it might work best without the grain.
Grain doesn't work in most cases for me but in this case it works to some extent and so I definitely wouldn't throw out this image.
The scene is "powerful" and exudes emotion with the look on the woman's and dog's faces - definitely a keeper.
I would play with applying the grain selectively to appropriate elements and with other editing techniques and effects.
If you like, post a link to the raw file if you have it and people here might come up with interesting processing suggestions using the raw file or the jpeg.
I see what you're saying. Yeah -- a coarser grain than what you initially used might be better. Would it be OK if I posted a version for you to consider?