Stop in for a cup of coffee

All the spouts nowdays are designed for a threaded stub 1/2" exposed. My old Delta had a 3 1/2" pipe exposed. I was afraid to try to unscrew the pipe from the valve in the wall.
Hard to visualize what's going on.