There are three types of comfort that God provides for us in the midst of suffering. 

First, the one we all want and pray for first is that He would miraculously heal us.  That He would change things so that they are no longer a struggle.  So that we are no longer suffering.

Second, also good but not the thing we’d like most, is that even if the situation doesn’t change, our heart/spirit would change towards it.  So if the person dies, or if the pain doesn’t cease, or if the struggle perseveres, then at least God will change our hearts so that it doesn’t affect us as badly.

Lastly, the one that we tend to not like, is that He is gracious to us and gives us endurance.  The circumstances do not change.  The pain in our souls does not cease.  But we do not lose faith, we do not turn away, we persevere.  God keeps us, even as we are suffering in the flesh and the heart.  This keeping is still tremendous grace.

That third one seems to be where I have been so often.  God is keeping me from abandoning Him.  He is giving me strength to persevere.  He is letting me endure the suffering.  I do not usually view this as Him comforting me.  But He is.  It is comfort.  And I need to see it as such.