The Upper Permian Longtan Formation in the Laoshan Uplift of the South Yellow Sea Basin hosts thick and distinctive tight sandstones. However, a comprehensive understanding of its pore structure and reservoir classification remains lacking. This study investigates the fully cored well, CSDP-2, utilizing thin section analysis, scanning electron microscopy, energy spectrum analysis, X-ray diffraction, high-pressure mercury intrusion, and nuclear magnetic resonance to characterize its petrophysical properties, pore space, and movable fluid characteristics. Additionally, fractal principles are further employed to examine reservoir heterogeneity and conduct a quantitative assessment, considering the complexity of tight sandstone pore structures. The findings reveal that the sandstones predominantly comprise feldspathic litharenites, with an average porosity of 1.567% and permeability of 0.099 mD, primarily containing intragranular pores. Two distinct sets of pores with significantly different sizes (r < 2 μm; r > 6 μm) were identified, displaying relatively high fractal dimensions and discrete distribution. Movable fluids primarily occupy pores with radii > 0.019 μm, reflecting pronounced overall heterogeneity. The reservoir was classified into three categories utilizing permeability, median radius, and movable fluid saturation as key evaluation parameters, with Class I representing a relatively high-quality reservoir. These findings advance our understanding of the pore development mechanism of tight sandstone reservoirs and provide geological evidence for further hydrocarbon exploration in this study area.