Yes, I did hear the Reith Lecture and subsequent discussion. I was pleased to hear a public denunciation of the referendum as a means of determining government policy. Margaret Thatcher did not like referenda - she considered them to be a tool of dictatorship.
I don't have a fundamental issue with referendums, but they should only be used in very specific circumstances, specifically:
1. Where the Government of the day wishes to make a change which is of constitutional significance
2. That the choices offered are clear and deliverable by the Government offering that referendum
If the second criterion isn't met I can see the case for a decision in 2 stages - an advisory stage to provide a mandate to negotiate a 'clear and deliverable' proposal. Then a second confirmatory vote to determine whether there is a mandate for that actual proposal. This could apply to both the Scottish IndyRef and Brexit.
However a referendum should never be called if a government doesn't want to change something (as was the case for Brexit) as the government of the day (2015 general election) did not want to leave the EU.