Train operator Northern has apologised after passengers experienced chaotic journeys in the the North West on Sunday - and admitted recent performances have not been good enough.