Why was Li Guangli, the general of the Second Division, highly valued by Emperor Wu of the Han Dynasty?

Li Guangli was not a brave man, but he was highly valued by Emperor Wu of the Han Dynasty because of his sister Li Furen's favor. Throughout Li Guangli's life, no matter whether he sent troops to Dawan or Xiongnu, he basically failed and failed again, and the only success was only because there were many people. BC 104, Li Guangli, as the general of the Second Division, attacked Dawan with 6,000 cavalry and tens of thousands of unscrupulous teenagers. Because Li Guangli's main purpose was to go to the Second Division of Dawan to win the good horses in Dawan, he was named the general of the Second Division, but other than that, he went to Dawan and ended in failure. Finally, he surrendered to the Huns, but it was also because of Wei Law's jealousy. He bribed the wizard to force Khan to kill Li Guangli in cold blood to sacrifice to heaven.