AV isn't perfect. It's supposed to be another layer in your defences, though, and not the only thing keeping the Big Bad World out.
Arguing that AV should not be used because it doesn't solve all malware issues is like arguing one shouldn't see a doctor until they can cure all illnesses.
Finally, imagine the PC of your typical user, please. Now ask yourself: would it really be more secure without an AV...?