I think that
"enjoyment comes partly from the fact that I know it's for a finite amount of time"
is key.
I had two years at home from when my eldest was 18 months and I started maternity leave with my second, and then several more years (during which time we had another child) of just teaching some evening classes.
I enjoyed the stay at home parent aspect especially as the children were close enough in age to do lots of developmentally useful fun stuff and endless hours outdoors, but when I didn't actually have a "project" in terms of setting up the new house, I absolutely hated the repetitive grind of housework and loathed myself if I didn't meet my own standards unless I could account for the time usefully spent with the children.
Once I was properly back at work we got a cleaner and honestly I was perfectly fine with the fact that at first her hourly rate was probably more than mine worked out hourly after tax and deductions.
Big projects can be motivating and satisfying but the day in, day out groundhog day of housework, food shopping, cooking, laundry certainly wasn't for me, and I know that if my children were at school (especially once settled, and assuming no health conditions/ SEND requiring missing lots of school) and I were a housewife I'd judge myself harshly if the house wasn't beautiful and sparkling clean always, because otherwise what would my role actually be? I'd hate that self imposed pressure!
Obviously I still feel self imposed pressure to ensure the children eat healthy meals and so on, but domesticity isn't all I do so I don't have the self imposed pressure to have a perfect house, no washing waiting, perfect meals etc. which I would feel if that was literally my sole role in life.
Obviously more importantly pension, financial independence etc. Even if I had a modest magic money tree to cover my current earnings and pension etc. though... No.
I could happily spend years travelling and hiking if the kids had all grown up and didn't need me and I had a mysterious source of modest income, but a housewife - no, I'd be miserable.