The Cygnus superbubble revisited