Unsteady internal flows in cylindrical rotating cavities with varying aspect ratios (AR=2, 6, 10, 18) are investigated using Large Eddy Simulation (LES). To capture realistic transient behavior, time-dependent rotational conditions are imposed, and the velocity fields are decomposed into rotation-induced and turbulence-induced components. The study focuses on the influence of the aspect ratio on flow structures at multiple axial locations. Spectrogram and energy heatmap analyses reveal that the axial velocity is the most sensitive indicator of aspect ratio variations, as it directly reflects the interference of the Ekman layer and secondary circulation originating from the end-walls. The results demonstrate that in low-aspect-ratio cases, the Ekman suction effect dominates the central core, leading to rapid turbulence transition and vortex fragmentation. Conversely, as the aspect ratio increases, the flow exhibits a non-linear stabilization process, eventually developing self-organized axial vortex filaments. This study provides a comprehensive physical interpretation of the transition from wall-dominated to core-independent flow regimes, offering fundamental insights into flow-induced vibrations in rotating systems.