a shot in the foot

The Japan Times Dec.19の記事です。

Are Europe’s Russia sanctions a shot in the foot?
If the European Union is enduring severe economic pain while Russia’s Ukraine war proceeds apace, sanctions become tantamount to self-flagellation.

"a shot in the foot" はロシアに対する制裁は自分の足を鉄砲で打つことになるの意味のようですが、辞書で確認します。

・Collins Dictionary: If you shoot yourself in the foot, something you say or do causes you harm.: If I was to insult the contestants I would be shooting myself in the foot.
・Farlex Dictionary of Idioms: To damage or impede one's own plans, progress, or actions through foolish actions or words.: I think we shot ourselves in the foot by firing her, because she knew more about the project than anyone else.
・McGraw-Hill Dictionary of American Idioms and Phrasal Verbs: to cause oneself difficulty; to be the author of one's own misfortune.: I am a master at shooting myself in the foot. Again, he shot himself in the foot by saying too much to the press.
・Cambridge English Dictionary: to do or say something that causes problems for you: I think you might be shooting yourself in the foot if you don't take his offer

確かにロシアに対する制裁はどの国でも経済的な反動があるでしょうが、ここは皆で協力して我慢すべきだと思います。