Personally, it depends. If I could automate taking the trash out, I would do probably want to do it (not sure though). But what remains when everything is automated ?

Well, so far we have been automating many things, and we are still busy working and living as always. It's of course impossible to automate everything - we always have things to do, by necessity by also by choice ; do we really want to be idle and contribute nothing to society ? I don't, and I am sure nobody does. Being useful is an essential need.

Is it pointless then, to automate more and more ? No. It's a way to move forward, and not necessarily a "bad" way. Just not the only way.