Half-Vortex Unbinding and Ising Transition in Constrained Superfluids