The SpaceX and Tesla billionaire said the role would 'send shockwaves through the system'