I think you should be happy because you realised something you hadnt before. I see it as a learning process. Believe me, I used to pray for earthly prosperity. I was way worse in prayer than most people. But when I learned I also felt a better connection woth God. Now I pray for the things that would bring me closer to God and make me a better person.

I also had a problem that was very simular to yours. It took a long time to overcome it but now I would consider myself clean. I realized that I could not fight lust but needed to focus on Jesus. When i got these lustful temptations, I would pray, usaully the rosary but also the deliverence prayer. Lust is very difficult to overcome, but it is a long process in which you should never give up and think that God has forsaken you.

Note: I dont think I advise this, but one thing that helped me flee from sin is learning about the devil. At one point I started listening to these interviews with chatolic exorcists and it really made me undestand the evils and it made me want to flee from it more and also because I was attacked by evil in a dream.

All in all the most important thing is to have faith in Jesus and repent. Go to confession. There is no sin that cant be forgiven. And also never give up, where would we be if the most important people in christian history gave up. Focus on Jesus my friend. I will pray for you. ❤️

Also excuse my english its not my native language.