The choice to have the Tesla and SpaceX billionaire host "S.N.L." has drawn praise, criticism and some veiled pushback from the show's own cast members.