In the contemporary sports product market, celebrity endorsements have emerged as a dominant marketing strategy, exerting a significant influence on consumers’ purchasing decisions. This study examines the impact of celebrity endorsements on consumer decision-making regarding sports brands, using Puma as a case study. The findings reveal that: (1) the congruence between celebrity endorsers and the Puma brand is positively correlated with consumer purchase intention; (2) the fan effect induced by celebrity endorsements leads to significant differences in purchase intention between fan and non-fan groups, with fans demonstrating a higher propensity for irrational consumption behavior; (3) irrespective of fan status, objective factors such as brand image, advertising media, and negative publicity surrounding endorsers play a more decisive role in shaping consumer motivation, indicating a predominant tendency toward rational consumption among the surveyed population. Based on these results, this study proposes two key recommendations: optimizing the strategic utilization of celebrity endorsements to enhance brand perception and maximizing the positive impact of celebrity endorsements while fostering rational sports consumption behavior. These findings offer valuable insights for the marketing strategies of domestic sports brands.