What is it about the nature of rope that allows you to pull it straight but you can't push it straight from the hind end?

A rope can take tension, but not compression. There are other things that behave the opposite - for example a stack of blocks behaves well under compression but not tension.