How to stop wanting to become famous, to overcome this incomprehensible and destroying all desire in you?

I would look for the roots of the query and try to highlight what exactly creates a painful effect in it, and what is a healthy and natural manifestation of your personality.

On the one hand, the desire to become famous without specific content - it's rather strange. But any pathological desire that obscures other aspects of life and does not have the conditions for acceptable and unacceptable performance is rather strange and potentially dangerous for the psyche. Here the question is not about desire, but under the conditions on which you agree or disagree with its execution, as well as whether you can survive its failure, whether you can build healthy relationships with people, progressively plan your activities and act on plan for how well you feel right now.

These are all very key issues worth paying attention to, I think. If you just don't like light without being famous, then you should already think about what exactly you put into this concept, what you expect from fame, what feeling and sensations. A sense of your own worth? Significance? Demand? Why can't you organize all this for yourself, what is blocking? Are there any objective, visibly present problems in your life, from which you distract yourself with worries about fame? If so, why are you not ready to solve them? and so on.

And so the desire for fame in itself is not something bad. First, it is ambition - the desire to influence the world as much as possible, and this is not bad. Secondly, it is demonstrativeness - the ability to enjoy attracting attention to oneself. And this is not good and not bad, this is different for all people - someone is demonstrative, someone is not very good, someone is selective (for example, I personally do not really like attention to myself, but attention to the fruits of my labor, in particular, I like my thoughts, so I sit here and write the answers). If you have a high degree of demonstrativeness, then it is quite possible that the celebrity media lifestyle is just right for you. But this quality can be realized in many ways, not only necessarily with world fame.

First, understand for yourself whether you really want to become famous, or is it a temporary desire that you will outgrow.
And if it turns out that you want, but perhaps you are simply afraid or doubt yourself, then by all means go to gain popularity. At least a little bit.
I am telling you as a person who has raved about the desire to become famous even for a day all his adult life - this will hardly pass, this is a very influential and tingling moment for the human psyche.
time will bear the first fruits, albeit at the bottom, but who was harmed by popularity? It certainly won't get any worse. And in addition to benefits for you, it will open the way to great prospects and increase self-esteem.
Believe Celebrity is an irrevocable act, once becoming famous, you will remain them forever. Namely famous, not popular (popularity must be constantly maintained).
My answer is to definitely go towards becoming famous. Good luck!