Former Chelsea striker Didier Drogba ended his glittering footballing career in defeat as Phoenix Rising lost to Louisville City in the USL Cup final.