Council hears Church school in rural village has struggled to attract pupils for more than a decade.