Obviously remain would lose a second referendum, but more importantly, a 2nd referendum is no more likely today than yesterday.
The only thing that has a parliamentary majority is a soft Brexit - that hasn’t changed.
The only long term impact is that Labour will go into the next election as the party that tried to stop Brexit (good if you’re a Tory).
But I suspect those who got us here will be long gone by then.