In general, this means when one thing goes inside another. For example, “the rain water penetrated his coat and made his shoulders wet”.
In the context of sex, it means putting something inside another person. The most obvious example of this would be a man putting his penis inside a woman’s vagina during traditional sexual intercourse, but it can apply in other cases too, e.g. using a finger or fingers.