The Turán density of three-uniform tight cycles