It would have been easy to believe that if "Yes" won that Cameron would have had to resign. Cameron let alone the next PM would not be eager to let another happen unless it is a campaign promise.
ps. Oil in the North Sea is some of the most expensive and intensive oil field to work on. I'm not sure why anyone thinks it would have made Scotland wealthy let alone make up for the shortfall in immediate budgets from going independent.