I am a Remainer but I hardly think it likely that MPs will vote Brexit down (and indeed much as I don't want to Leave, I can see that if they did so that would bring with it a whole host of other problems).
That said I am glad at least that Parliament gets to trigger A50 and that the govt can't just go off on a jolly of its own on this. Of course the judgment doesn't help us predict how this will all happen in practice. How much information will the govt have to give Parliament before it votes to trigger? The judgment doesn't prescribe any of that, but I guess it is in the govt's interests (given they have foolishly already promised to trigger in March 17, which I thought was rash given how rubbish their arguments were on the A50 case!) to be as forthcoming as possible to maximise the chance of Parliament approving the trigger within the govt's timetable.
Note that as far as I can see this judgment does not give parliament a seat at the table in negotiating with the EU/world around (1) the two year divorce process or (2) trade deals going forward from Brexit, or the right to approve any of these things.
If the govt loses again in the Supreme Court, will they appeal to the European Court - what an ironic twist that would be (and political dynamite, particularly if the govt loses there too).