Well, in this point there are different schools in Agile. The most purist would say that QA cannot act as gatekeepers for a release, only the CI/CD with automatic tests. If you can release without QA manual testing the application, then you do not need to run the application manually.

Anyway, it is impossible to remove things like exploratory testing. But we have to consider that 1) it is impossible to avoid bugs, 2) a human cannot test everything each time (not at least with a reasonable budget). So, if tests are reliable, maybe it is not so crazy idea to not need to run it manually, right?