AV software isn't there to prevent ingenious hackers to take control of random computers. Yes, it actually might create more surface for that purpose.
It exists because most users do not have any understanding of the platform, and will just click on "accept", "yes" and "ok" hoping things will turn out well. AV are pretty decent at mitigating that. At the cost of some performance loss, you'll avoid having a bunch of ads and popups take over your computer, or at least mitigate the phenomenon.
AVs are still useful for "we're employing 1000s of people, some of them are bound to open that bad word document in the email". Useless for targeted attacks, but useful for worms with signatures known for weeks. If you can't deal with the issue in some other way, AVs still give you something.
For websites, malware hosts can be easily blocked at the gateway level. This won't protect you if someone manages to host malware on a common site like yahoo.com but will catch the vast majority.
These days it's pretty easy to circumvent or disable Antivirus or obfuscate your malware form it. If malware manages to get itself onto a user's machine then you've already lost.
In fact, considering the massive vulnerabilities in AV software discovered by e.g. Googles Zero project, I'm pretty sure the security gain has already slipped into "negative effect" territory five years ago.