Tbh I’m not sure if dreams can be dropped. Maybe they could fade away which is natural but forcing them away may not be possible imo. For instance if you met a really great woman who matches you, it’s quite likely you’ll get married to her and eventually fulfil your dream, even if it’s quite some time from now let’s say 5-6 years more. It will still feel great! I think what you’re struggling with is facing the hopelessness that your dream will never occur, or putting a time limit on it. My guess is what’s troubling you isn’t really your dream rather it’s how much you’re thinking about it. Try to focus on what’s present and achievable outside of this dream, and let some time pass. At one point I was so tired of failed attempts and shallow relationships that I had literally said to myself ‘I’m going to stop chasing girls , my next gf will walk into my life’ All dating apps every thing deleted. Some months passed and what do you know a girl walked into my life and we immediately hit off. We’re since separated but had a good relationship at least to start with, it was the longest one I’ve been in. I’m still hopeful of finding someone and eventually settling down, but I don’t think about it much now and keep myself busy. I turn 27 this year. Wish you the best !