Self-defeating fortune-telling stories

What is the historical story of idioms self-defeating? Does this idiom mean anything to us?

Self-defeating is an idiom story. The story is about the Northern Song Dynasty.

There was a painter named Sun Zhiwei in the Northern Song Dynasty who was good at figure painting. On one occasion, entrusted by Chengdu Shouning Temple, he drew a picture of Nine Glory Xing Jun ... He carefully hooked the picture with a pen, leaving only the last coloring process for his disciples to finish. One of his disciples, Tong Renyi, in order to show off his cleverness, felt that the teacher's painting was missing something, so he drew a gorgeous red lotus flower on the bottle mouth with his heart. Sun Zhiwei came back from a friend's house and found a lotus flower in the bottle in the boy's hand. He said with anger and laughter, this is simply self-defeating. The bottle in the boy's hand is a demon bottle used by the water heating star to subdue the monster. It's a big joke that you added lotus flowers and turned Aquarius into an ordinary vase. As he spoke, he tore the painting to pieces. The disciples looked at Tong Renyi and bowed their heads in silence.

Self-defeating is trying to be clever, but the result is very bad. You thought you were smart and opportunistic, but you failed, making the situation worse. We are warned to think everything through, and never be smart and self-righteous, which makes people laugh.