So you're disappointed because GOD told you to do something & it failed. Well, maybe it wasn't GOD. Maybe it was you. And that's OK.
Sometimes we get confused & frustrated because we were so sure we were doing a GOD thing & it turns out we weren't.
It happens to everyone. Read the Apostle Paul's experience in Acts 16:6-10.
Missing GOD (or better, misunderstanding what GOD wants you to do) is a part of learning to be led by His Spirit.
1. Make a course correction & keep walking with GOD.
2. Ask Him to teach you to know His voice better.
3. Pray, "Lead me Holy Spirit" often.
4. Spend time in the Word & Prayer.
We've all missed GOD b4. You'll be fine. Be encouraged!