This is mainly used to express the feeling of mortification after a particularly humiliating social experience, leaving you wanting to "crawl in a hole and die" rather than face the people it happened in front of.
Susan: Did you really skip wearing underwear today?
Angela: Yes! And everyone at school saw when I fell down! I just wanna crawl in a hole and die, now