A motion to sanction unions nationally failed but provincial church bodies will still be able to decide for themselves