Twitter CEO Parag Agrawal has only been on the job for a few months, but Elon Musk is expected to take the reins of the company temporarily once the deal is completed.