You're not alone. In mark 14:36, Jesus prayed in the garden the night before his crucifixion asking God for one thing. "Take this cup from me." But God didn't. He knew that this was what needed to be done. It was for our good that God said no. But no one could see the bigger picture except for God. God saw the resurrection coming. The moment when death defeated the grave and our debt was paid in full forever.
There is a resurrection coming for you. Death is not the end. Your barren womb is not the end. Your failing marriage is not the end. Through the death, redemption is found, the savior comes, the spirit leads, eternal life is given, God's love was poured out, life began, a promise fulfilled.
The no is for our good and only He can see it all. Be expectant, be faithful, and be hopeful because the pain will end. And there will be rejoicing. It may not look like we thought, but something great will happen because of that "no." Just ask Jesus.