He's said in interviews he had a 5 year plan, saying that J. Michael Straczynski was his hero and Babylon 5 and it's 5 year arc a thing of beauty and he was going to emulate it. So he probably did at least have a vague sense of the arc of the Winchesters, even if the specifics might not have been planned out fromt the get go