If a member of one of the Foundation’s advisory committees attends the site visit, does that mean we have a better chance of receiving funding?

Not really, since funding depends on many factors. Program officers think of themselves as being advocates for the organization they are reviewing. Assuming the site visit goes well, if an advisory committee member attends the site visit your organization will have two advocates, rather than one, at the meeting where funding is decided.