Are you sure the pipe extending out of the faucet just isn’t stuck on there and can be removed? If so, just take it off and thread it back on to the wall and then you can use any normal faucet from HD. I have one similar to that when I was replacing my shower head and noticed it was getting stuck to the head rather than staying in the wall.