Network Rail manager resigns after passengers left stranded