molly andtreacle both have a point, which is that what you want from a job matters a lot. However, perhaps when we are younger what matters is the job itself; and when we are older with more complex lives, what matters is the mixture of job, stress levels, flexibility, etc. being higher paid is important in that mix mainly as it allows you to work PT or retire younger if you want to. If you are lower paid than you have to work more hours to get the same money.
Of course doi g something you hate is not an option, but just becau you hate one well paid job it doesn't follow you would hate all well paid jobs. It may depend on why that job is well paid. If they are buying your soul and the hours are hellish, you never switch off, etc. then that only suits a small number of ppl. If OTOH you develop a niche skill to a high level, then you can up your pay without that.
Bt of course treacle is right, we fall into our jobs and our existing employers are not likely to support retraining. Deciding to retrain is a big step. Sometimes you can see a way to edge into it; but sometimes it involves a big burning of boats and a big risk.
That's why I would encourage SAHM to think about what they would like their future careers to look like, and do any retraining they need while they have a bit of flexibility, such as when the kids are at school all day but still too young for you to want to return to paid work.