No, that is not the idea, because automatability and undesirability of tasks are largely unrelated. We will habe to find a way to deal with tasks that are unpleasant but can't be automated.
Or find people to do them who are sufficiently desperate and low in status, compensate them just enough, make sure they don't have enough savings to walk, convince them they can't be hired elsewhere, collude with other employers to set wages, make harsh examples of anyone who pushes back, and
do anything to prevent workers from organizing.
This is much cheaper and considered socially acceptable or even laudable (depending on the country, certainly in the US). Businesses with a large share of their costs in unpleasant labor either do this or get destroyed by the competition. That's capitalism.