When I was young I lived in a commune of sorts, with artists and guppies and what not. Every few weeks a couple of us did just that, because why wouldn't we?

Also later when I worked in a group gole for elderly autistic people that experience came in handy as I was used to the smell. Usually I ended up doing the shittiest (harhar) cleaning duties and it never really bothered me even though we were supposed to rotate. One of the nurses with over a decade of experience refused to even enter a room while I was emptying the stomach contents of one particularly tricky patient (he essentially had plugs straight into his stomach for both in and output, generated some interesting smells for sure).

Sure, I got paid for the latter half, but I still did that shit daily. Later when I became a father there was absolutely nothing that could faze me anymore. Sort of glad I got to experience all that, weirdly enough.

If something really needs to get done, like repairing necessary sewer systems, then it will get done, because it needs to. Do you really think that people who have the skills to repair the water treatment plant are going to just deal with sewage backing up into their home because they don't want to do the work?

For a more comprehensive analysis of the question, I'd direct your attention towards an anarchist FAQ. I'll quote a few choice sections below, but the link goes into great detail, comparing and contrasting multiple approaches to handling the problem.

There are some jobs that few, if any, would enjoy (for example, collecting rubbish, processing sewage, dangerous work, etc.). So how would an anarchist society deal with it?

[...]

It would be easy to imagine a free community sharing such tasks as fairly as possible between a community's members by, for example, allocating a few days a month to all fit members of a community to do work which no one volunteers to do. This would soon ensure that it would be done, particularly if it were part of a festival or before a party. In this way, every one shares in the unpleasant as well as pleasant tasks (and, of course, minimises the time any one individual has to spend on it). Or, for tasks which are very popular, individuals would also have to do unpleasant tasks as well. In this way, popular and unpopular tasks could balance each other out. Or such tasks could be rotated randomly by lottery. The possibilities are many and, undoubtedly, a free people will try many different ones in different areas.

[...]

Of course, no system is perfect -- we are sure that not everyone will be able to do the work they enjoy the most (this is also the case under capitalism, we may add). In an anarchist society every method of ensuring that individuals pursue the work they are interested in would be investigated. If a possible solution can be found, we are sure that it will. What a free society would make sure of was that neither the capitalist market redeveloped (which ensures that the majority are marginalised into wage slavery) or a state socialist "labour army" type allocation process developed (which would ensure that free socialism did not remain free or socialist for long).

In this manner, anarchism will be able to ensure the principle of voluntary labour and free association as well as making sure that unpleasant and unwanted "work" is done. Moreover, most anarchists are sure that in a free society such requirements to encourage people to volunteer for unpleasant work will disappear over time as feelings of mutual aid and solidarity become more and more common place. Indeed, it is likely that people will gain respect for doing jobs that others might find unpleasant and so it might become "glamorous" to do such activity. Showing off to friends can be a powerful stimulus in doing any activity.