Subjective. Avatar was still accepted across the globe like never before. Such acceptance you can't say the story wasn't liked. If it wasn't then it wouldn't have been the no.1 grosser for 10 long years.
Vfx alone won't lift a bad film. You'll find all the right examples for that. Bond Series don't survive on vfx. That is just upgrading to the current norms. Bond Series without a concrete script will be a downer any day. No amount vfx extravaganza would save it. And the production house wouldn't be spending so much on bad vfx. And even if the film does have glitchy vfx & still a good story, it will be accepted.
Fast & Furious series has bad vfx over & over again. Don't see that bothering the audience.