Elon Musk tweeted Tuesday night that he would step down as Twitter's CEO as soon as he "finds someone foolish enough to take the job."