why the rear stagnation point happens.

I would expect it to be a consequence of the unfavorable pressure
gradient that occurs past the point of lowest pressure. The steady
deceleration brings velocity down to zero.