If you don't know it can be better, you're fine with it. But when someone shows you the proper stuff, you can't stand the other shit.
I think we will look back at AI "slop" as a temporary point in time where people were creating bad content, and people were defending it as good even when it was not. Instead, as you say, AI video will fall into the background as a tool creators use, just like cameras or CGI. But in my opinion it won't be that people can't tell that AI was used at all. Rather, it will be that they won't care if there is still a creative vision behind it.
At least, that is what I hope compared to the outcome where there are no creators and people just watch Sora videos tailored to them all day.
https://theoatmeal.com/comics/ai_art said it better than I ever could
These days, though, it's not as common as it used to be. Kimi K2, in particular, is a weirdly good and stylistically flexible writer.
How sad, what it does to us.