Why can't I create a pipe from this curve?
For this setup to work, your circle has to lay flat on Z axis.Like this:


And it has to have this rotation applied, so you can rotate it in object mode and press Ctrl+A and choose Rotation or rotate it in edit mode. It will have exactly the same effect.