What's unique about Honor's MILFness is how essential it is to her personality. Her son isn't just an accessory that gets forgotten about until we need some last minute drama. And her relationship with her husband isn't constantly on the rocks. Being a good wife and mother are essential parts of her character and the main reason she does pretty much anything.
Superman would still do Superman shit even if he knew Louis and John would never be in any danger. Reed and Sue would still do Fantastic Four shit even if they knew Franklin and Valeria would never be in any danger. Honor doesn't give a fuck about anything outside of her family.
If Talia had just let her stay a housewife, she would have just stayed a housewife and not gone all John Wick on half the Underlife.