Re: Non-binding it may be, but we're still doomed.
As you say, there's a good chance we'll see civil unrest in the two main opposing scenarios: If the government just turns around and says "No, we've decided we're not leaving after all" or if they end up taking us out and people become worse off and unable to afford basic necessities due to job losses and rising prices. (And ironically, I think the people most likely to be involved would largely be in the intersection of a Venn diagram of both).
That's why I honestly believe that the so-called "People's Vote" option is probably the best way forward now. It isn't back-pedalling to say to the voting public "Look, we've listened to you, and we're going to listen to you again - this is what's on the table, so what do you think?"
There's still a possibility of civil unrest in that scenario, but it's the least likely to lead to it, and if it does it would probably be the least amount.
But since our PM is more interested in trying to keep her party healthy, rather than the country she and it serves, I might have to learn about gardening, and growing my own veg.