Latest survey finds that majority of residents support the 30-acre facility, two years after golfers claimed a public consultation was taken over by a ‘cycling lobby on steroids’