The sliding player must make contact with the ball before touching the other player, otherwise it’s a foul.

If it was unintentional, then a yellow card makes sense. If it was intentional, then definitely a red card.

Of course it also depends on the context. If this player had been warned about aggressive tackling, or already had a yellow card, then a red card might be warranted.