Against the backdrop of the strategies for rural revitalization and the integration of agriculture, culture, and tourism, farm stay, as a vital carrier, requires a systematic analysis of its resource integration effectiveness and the actual needs of tourists. Taking Chongqing City as an example, this study leverages tourist reviews from the Dianping platform (China’s leading consumer review site) and employs a combination of TF-IDF keyword extraction, SnowNLP sentiment analysis, and LDA topic modeling to dissect tourists’ perception characteristics and latent demands for agritourism resources from the demand side. The findings reveal that agricultural and tourism elements garner significant attention, while cultural resources are notably underperceived, indicating an imbalanced integration structure. Sentiment is predominantly positive, yet negative feedback highlights issues in service management, transportation, and homogenized experiences. Latent demands converge on three dimensions: deepening agricultural experiences, enhancing cultural participation and interaction, and improving environmental and service quality. Based on these findings, this study proposes integration enhancement strategies, including agricultural branding, cultural vitalization, service intelligence, and multi-faceted collaboration, to drive experience upgrades and sustainable development in farm stays, offering theoretical references and practical pathways for rural tourism integration in similar regions.