I can provide a personal opinion on this.
I truly believe that God has a plan for us. Sometimes, what we want or what we do isn’t what God intends for us, and so we fail - but only to be exposed to much greater possibilities. There have been times when I’ve desperately wanted to achieve or do something and it hasn’t been made possible. And while in those times my failure has left me feeling disappointed, looking back I’ve realised that the opportunities arising as a result of my failure or instead of my success have been truly amazing.
In regards to Scriptural references, passages that spring to mind relate to the conduct of the Israelites of the Old Testament and Peter’s denial of Jesus. When the Israelites asked God for an earthly king, God knew they would fail in their devotion to Him, yet He gave them a king regardless. Peter still denied Jesus, even though he swore he would never do so. So God knows we are going to fail, He lets us fail - because it is through failure that we can truly know success.
I don’t know, maybe that’s a very basic idea or understanding of Scripture. But I believe failure is an important and necessary thing.
I hope this is a suitable answer.
