It depends. Some of the most intelligent and insightful people I've worked with were actors and directors who had empathy and deep insights into the human condition.
Also, I do think that in the US, there is something inspiring about the fact that anyone in theory could be elected to office, especially President.
Being a celebrity does not make you a leader. But neither should it exclude you either.
Trump's problem is not that he's a celebrity. It is that he is a bad person.