That kind of weary honesty is heard by God far more than we realize. When you keep crying out, even through the tiredness and the drink, you are not showing a lack of faith. You are showing that the faith is still there, struggling beneath the weight. The proving of your faith is never really for God's benefit. He already knows whether it is genuine. The testing of it is for you, so you can see that it holds. So you can stop looking in the mirror and trying to figure it out on your own, and instead see Jesus holding onto you.
You asked what will happen to your mind, your thoughts, your soul, and your dreams when you die. The body is put in the ground or scattered on the water, and it is for those left behind. But for you, the one who has trusted in Jesus Christ, death has lost its sting. Through one man, sin and death entered the world, and so death passed to all of us. But through one Man, Jesus Christ, the gift of righteousness reigns in life. Men and women of faith still die. They have always died. Stephen was stoned. The faithful were tortured, and they did not accept a cheap deliverance because they were looking for a better resurrection. To die in faith is not a failure of faith. It is the final act of trusting that the resurrection to eternal life is real, and that the grave has no victory over you.
The fact that you plan to get up and go to work tomorrow, to support your wife and your adult children, is not a small thing. True faith is not some passive, floating sentiment. It is active. A person who says, “I have faith,” but has no corresponding action in life has a faith that is dead. You going to work, doing the best you can for your bosses and coworkers, even when your soul feels like a dry desert, that is the work of faith. It is the labor that flows from love. It is not trying to earn anything from God. It is simply the evidence that a living faith is still in there, pushing you forward when the feelings are not.
Laying there feeling tired of asking for help is often when the most effectual prayer happens. The prayer that rises out of desperation, the cry that is truly from the heart, is the one James wrote about. Elijah was a man with a nature just like ours, and he prayed earnestly. The fervent prayer of a man who belongs to God accomplishes much. You don’t need to phrase it perfectly or feel holy. You simply need to turn the heart toward God, even if that turning feels like a heavy, groaning effort right now. Prayer is not just a monologue. As you lay there, let there be a moment of listening too, trusting that being justified by faith gives you peace with God and access into the grace in which you stand.
You think about looking in the mirror and figuring it out alone, but that is the last thing you need. The enemy wants you to be moved away from your faith by the afflictions and the fatigue. He wants you to isolate and rely on your own strength. But the just shall live by faith, not by self-analysis. Faith, even as small as a grain of mustard seed, is enough. That kind of faith simply says, “Lord, not my will, but Yours be done. I know You do all things well.” Such a faith can move the mountains of fear and doubt that crowd in on you in the dark. It might not change your circumstances overnight, but it changes your standing before God. The Lord hears you. Jesus Christ is your life, and in Him, all the promises of God are yes and amen. Put down the weight of trying to carry your own soul, and rest in the One who holds it securely.