A CEO can be valuable while still doing nothing with a simple explanation: they are cult figures whose purpose is to increase the stock value. This is obvious in the case of a drug addict like Elon like you describe, but others are increasingly copying the playbook.