I would find "sex is permissible in mixed-sex civil partnerships but not same-sex ones" a vastly more offensive position than "sex is only permissible within marriage".

Obviously the failure of the CoE to recognise my marriage is a problem, but it's not news.

(Also the Church is more than just its leadership, and includes quite a lot of LGBT people.)