Pretty sure it will end with Sam sacrificing himself to keep Lucifer contained in Hell, while Dean finally gets to live a normal life and settle down with a nice woman. They may do a sequel series after that where somehow Sam gets out of Hell, but that just seems silly to me, so I probably won't watch it.