Why do people try to get close to you, only to push you away in the end?

Because they get bored of playing close and once the newness and the getting to know part of the relationship becomes stagnant, they are unwilling to put in the work to maintain it.
For some, that's the thrill of relations.