Do people live in denial of how miserable life is with regards to work?

I can't stand when people advise others not to settle for a job they don't enjoy, and to get a job that they truly love. As lovely a sentiment as that is, it's unsustainable for everyone to do that. There'll always be a lot of jobs that no one wants or would ever enjoy. Mindnumbing braindead work that provides no stimulus whatsoever. Maybe there'll be the rare exception who will like that job, but the vast majority of those workers will hate it. Those jobs are essential though, we desperately need cleaners, stockfillers, factory workers, etc. So someone has to do those jobs. If everyone only did their dream job, we'd just have a lot of singers, artists, actors and athletes, while all the cleaning, stocking and manufacturing work falls into disrepair. Therefore society is built on people doing jobs they hate. So it annoys me when people romantically ramble on about finding a meaningful job and aiming for your dreams, and speaking so idealistically about life, when they themselves are directly benefitting from miserable people in the most tragic of jobs.

Is it just that everyone avoids admitting all this to themselves because they don't want to face the truth that life is miserable? They'd rather think more comforting thoughts and stray away from any train of thought that might lead to this conclusion? Am I breaking an unwritten social convention here by openly talking about this? I know it's depressing to admit it but I think it's important that we be truthful about this.