He remains assimilated for a significant period of time, becoming Locutus of Borg, but he is eventually rescued and returned to his human form.
It's important to distinguish between "turning into" and "being assimilated." Turning into implies a transformation into a new species, while assimilation means being incorporated into a collective being, but retaining some individual identity.