No one ever wants to do most of the work they do. That is the literal definition of work, as opposed to a hobby. You do it because otherwise you and your children starve. Job satisfaction is optional (and may cut into your salary).
A lot of work happens (or happened) because everyone is in agreement that it kinda should be done.
Like for example, you do need food so someone will probably have to do the things that lead to there being food.
These things of course aren't always fun. Who wants to collect cow manure after all. But they pay into something where everyone agrees that it should be happening and it should do so as the result of a collective effort.
The stuff I was talking about either has no such meta layer or has so many layers of meta, that it is incomprehensible for normal human minds, which, evidently, makes people miserable.
Lots of things "kinda should be done" but people enjoy enough that payment is not required. You said that food production needs to be done, but food production is useless unless someone eats that food. But although eating is necessary for civilization, eating is considered work. Why not? Because people are willing to eat without being paid for it.