What does stick one's foot in one's mouth mean?

It is when a person says something accidentally or stupid and the listener is embarrassed

The image is of you opening your mouth, and you accidentally kick yourself in it because you are clumsy; you have "put your foot in it" and said something you should not have said.

To put your foot in your mouth means ''to say something foolish''.