I think you mean that there are a lot of jobs that while serving a good purpose, aren’t necessarily enjoyed by many. I’m not sure how much that has to be the case. In any case, we should strive to maximize the jobs that are both sufficiently enjoyable and purposeful.

The problem I see today is that there is a lot of “bullshit” work being done that doesn’t really serve any good purpose, or even makes things worse in the world, and not enough people rejecting that state of affairs.

I agree about dignity and compensation.

There's a difference between personal purpose and community purpose. I don't expect a city trash collector to consider their work to be their life's purpose, even if they do experience the work as having some purpose/value to the community.

The BS jobs hypothesis, popularized by David Graeber, is IMO quite flawed. It's a way to look at the world without having to get your mind dirty understanding how stuff actually works. Sometimes that can be a good stepping stone to asking "just why are we doing it this way?". However, the broader observation that Graeber makes (essentially: "everybody, especially the people doing them, know it is bullshit") points instead to the disconnect people experience between the work being done by <their organization> and the actual stuff that they do. No doubt there are some true BS jobs, but I think far less of them than is often supposed. You and/or the person doing them may not see why they are there (and that is a problem), but that doesn't make them BS.