Abstract: This study focuses on the learning difficulties within the conflict between learning and training in the cultivation of competitive sports talents in schools. Taking the administrators, teachers, coaches, and student athletes from primary, secondary, and higher education institutions as research subjects, adopted expert consultation, field investigation and grounded theory research methods to analyze the tripartite factors of learning difficulties. Objectively, there are deficiencies in cultivating metacognitive abilities, mismatched learning strategies among student athletes, antagonism between learning and training “excitement points”, and insufficient time investment; Subjectively, there are attitudes and cognitive biases towards academic work among students, coaches, and cultural teachers, as well as the influence of deviant habits and identity conflicts; In terms of environmental and institutional factors, there are inappropriate teaching methods and management measures, adverse effects of utilitarian educational values, and significant negative peer effects. Based on this, it is proposed to attach importance to the cultivation of metacognition during sensitive periods, design media related to sports and learning, explore the transformation method of dual “excitement points”, construct an integrated development model of the “subject” matrix of education and sports, cultivate positive habits, integrate dual identity recognition, set “rigid” conditions for teaching and training, create a value chain for primary, secondary, and tertiary schools in the same direction, and give full play to the positive leadership function of the same group, in order to promote the deep integration of sports and education, and build a sports development paradigm of learning and training excellence.