The goal of automation is to reduce the costs of goods and services, with the cost savings getting passed on to consumers of those goods and services. Whether we need more goods and services is a better question.