I think the company needs to do more than get a new CEO. They need to make Musk sell his majority share in the company. He needs to be ousted from all decision making. With enough time they could disassociate from Musk and become a good company again.
A good company who's cars fall to pieces or lock you in then catch fire?
I honestly think that everything cyber truck related is all Musk and a rushed vanity project. Stupid thing. The other cars, model 3 and y are solid enough products I think. EVs have a reputation overall of bursting into flames and being generally terrible. But big oil likes that story too.