The danger of sin is that anyone can fall, no matter how spiritually strong they are. Danger is not in making the big mistake, but rather making the small ones leading up to the big mistake. We should not be worried about being presented with a big sinful temptation and falling into it, but rather the indifference towards sinful patterns leading up to the temptation (not to say when you are tempted you are sinning, but rather when you fall to the temptation, perhaps you had been sinning prior.)
Take King David for example. His big mistake, was arguably his adultery with Bathsheba. David didn’t randomly give into sin… He ALREADY had been giving into sin. He was supposed to be out fighting with his men, not staying home. Had David been presented the temptation in any other situation, I believe he would have resisted the temptation and not committed adultery. But he gave into temptation earlier and thus numbed his heart towards the Holy Spirit, so that when the next temptation came, and one on a larger scale, he did not respond to the dulled voice of the Holy Spirit.
Applications to this are many. We need to not only pray that God will deliver us in time of great temptation, but also ask his help to say no to the small temptations. This is why I believe we need to bring EVERYTHING to God in prayer. Not just the big things, we need to bring the tiny, small things to Him too. Perhaps this is why Paul urges us to pray without ceasing.
“No temptation has overtaken you that is not common to man. God is faithful, and he will not let you be tempted beyond your ability, but with the temptation he will also provide the way of escape, that you may be able to endure it.” – 1 Corinthians 10:13