I grew up Jewish and don’t consider it a slur against the woman, it’s meant to guilt a Jewish man for being with a non-Jewish woman in the first place. “Oh, so he married a shik—”
It’s derogatory and meant as so as quite a few descriptions of the goyim are
It can pass in comedy maybe in proper context
Yiddish is not a warm and endearing tongue
It can be coarse and yes funny
No accident so many great comedians once knew it
I miss those guys