I find a bit unlikely Elon will step down this quick - he might find some trick to get out of this dilemma he created for himself - and I also find it highly unlikely to make Twitter CEO people like Snowden or Snoop Dogg or others who would propose themselves as CEO.
To be honest, I am not surprised that he already wants to step down as twitter CEO as he is known for losing interest in something fast (Bitcoin, Doge etc) so this would be just business as usual for him. He will soon find new toy anyway.
I've read that Elon asked in a poll if he should step down as CEO and the answer was yes. Let's see what he does, but the people have spoken.
He is of course not stepping down because of the poll results, as he obviously decided that before, and this was just something for the audience.