I can’t remember who said this in the show in Universe; maybe Janeway? But I think a similar question was posed, and the answer was that nobody would have anything to do if exploration was entirely automated. It’s fun and exciting and gives people’s lives meaning.

My headcanon is that many mundane things are automated, and we don’t see them because they aren’t plot-relevant.