I think some do, some don't. In the past, surely few did.
Ernest Hemingway seemingly blamed ECT for his suicide, saying it was a brilliant cure, but they lost the patient.
Given how disabling the meds are, I think that it is hard to take the meds and maintain any occupation at all. Lithium isn't so bad, or depakote, but nowadays, the docs are pushing antipsychotics onto people, and you may as well give it up and go on disability if you take those meds long term, for most people. Lamictal turned out to be a big fake, and doesn't do any better than placebo in most studies. so there went one of the less side effect laden meds out the window.
I suspect few famous people with bipolar are taking antipsychotic medications, if they are still working.