Got a pretty rare opportunity to work right at the top of my field, but required moving to another country with bizarre immigration laws that allowed me to bring a spouse, but that the spouse would not be allowed to be gainfully employed while there. Was once in a life time kinda thing for me, but meant partner would have to give up their career for 3-5 years and we made the decision it would be worth it in the long run.
Honestly, it was more like my partner having to be okay with it. I'm living/working the dream, great for me, they're the who is having to bide their time. Maybe if my partner wasn't very ambitious and was all "oh no it's fine, I'll just hang out all day lovely!" I'd feel differently, but I know it was sometimes frustrating for them.
Other hypothetical situations where I'd be okay with it is if a) my money was good enough to provide for us both comfortably and b) they had a particular interest/project/organization that brought in little to no money, but that my partner was extremely committed to. E.g. if they wanted to write a novel, but were non-committal, sometimes typing away for a couple of hours every few days, then no, not cool. But if they said "Okay, I have an idea, I think it's good, and I want to make it happen" and proceed to treat working on it like a full time job then I'd be cool with that I think.