Credit to Musk here for being smart enough not to get in one of his own rockets (yet).
I don't think it's the CEO's job to be a test pilot. I think that's pretty crazy actually.
I know someone who is a test pilot. He's trained a long time to do it. You want someone in the craft that is an expert at both piloting spacecraft and the engineering of the craft. Musk is certainly no pilot and the job of CEO does not require you to have those skills.
It could be argued that since these systems are fully automated that you don't need anyone with special skills there. But being a programmer I don't trust software for every situation. So I sure think if you are going to put a person on it, they should be able to intervene if needed. There should be a purpose to their risk.