"It's going to be sad, but we also wanted to try and capture something that's beautiful and a little hopeful about the human experience," creator Dan Fogelman tells PEOPLE of Rebecca's fate