The empty church will be flattened to make way for a new four-storey apartment block