A governor of Westbury Leigh Primary School has resigned from his post because of what he thinks is a "lurid" sex education video.