Much of the software development in website development is done using agile methods. Test Automation is usually necessary to keep up with the speed.
It’s not really a question of whether automation is useful. Only a few people would rather repeat the same tasks many times every day than to let a computer do them. The question is whether the benefits are bigger than the costs. There will always be costs; automation is an investment. Businesses expect a return for their investment.