Musk was ‘a source of consternation’ for some Trump officials, CNN political analyst Maggie Haberman said