Well... when we talk about our children we say, "The Boy" (he's 18) and "The Girl" (she's 19). My husband is, well, "My Husband", and the pride in his voice when he says, "MY Wife" never fails to make my toes curl.
I can't imagine him ever using "the wife" in a dismissive or objectifying way, so I can't imagine it bothering me. Intent is everything. I'd object to him using my own proper name, if he used it dismissively! "I can't go out tonight because of
Magpie." Yeah, I'd object to that, no matter what he called me.
As for what other people do, that's up to them. If they like it, great! If they don't, then they should say something.
Though... whether family members actually respect their requests is another issue entirely. My mum - an old school Sixties Feminist - would never let anyone refer to her as "Magpie's mom" or "mother of one" or any descriptor that in any way "reduced" her to being "just a mom" as she put it. (Which stings a little, when you're the child.) Even if she wasn't divorced, "wife" would have been right out. She's DOCTOR Lastname and that's all there is to it. So, rather obnoxiously, I deliberately dedicated the book I wrote to "Mom", and then thanked "Doctor Lastname" in the backpages as if she's two different people.
Honestly, though, the idea that being identified as a wife or mother is in any way demeaning feels very anti-feminist to me. What is it about my work that makes me in any way a lesser person? Wife and mother are important roles! Why shouldn't I be as respected for those, as I would be for any other work I do (like "tutor" and "author" and "artist")?