I don't have much I can offer on this situation but I hope what I do know might help a little.
From what I've noticed fame tends to happen to people who are good at their craft/job or something that happens kind of randomly. Like, there's a need, or a niche and the person that comes along gets the attention for it.
I also don't have much life experience but if you really want to succeed at that dream you have to make sure you're putting steps towards it. Like if you want to be a famous artist, you practice everyday, take lessons, promote yourself etc.
So what you have to judge is how severe your depression is and how attainable your goal is in depression/while being depressed. For me, I have been told I would have been famous at something were it not for my depression. Unfortunately, I cannot alter the past and the decisions I make now create my future. You just have to try your best and if you're not super famous then you have to be ok with the fact that you did the best you could do. Please be easy on yourself.
It also helps to take stuff one step at a time. I tend to believe fame usually goes to those who put a lot of effort and work into a subject and it will come naturally if you are good or exceptional, but maybe I'm wrong. I don't know.
Are there other fields that could use your imagination and creativity? Or is this the only dream you have? I tend to see dreaming of future possibilities (while having depression) as a balancing act - what I can do, I can do; what I can't, I can't. etc. All I know is to try my best and see what works out.