This is pretty much what Job said: Bad things happen to good people. Good things happen to bad people.
It bothered his idea of what God was "about"?
Nothing got resolved, really. What he saw didn't tell him there was no God but it didn't inform him about how God relates to our actions down here.
I don't pray for touchdowns or parking places. I don't pray for a cure for my cancer.
I do pray for love, the ability to keep from freezing up in the face of futility. I do believe we have to love.
That was in the end the big thing Jesus said. Love each other.
That is a huge thing to do, actually.
It is a really huge thing to do. That is why I pray for help with it.