Target has made operational mistakes and faced backlash over its rollback of DEI initiatives, leading shoppers to choose rivals like Costco and Walmart.