Flow fluctuations have emerged as a promising hemodynamic metric for understanding of hemodynamics in intracranial aneurysms. Several investigations have reported flow instabilities using numerical tools. In this study, the occurrence of flow fluctuations is investigated using either Newtonian or non-Newtonian fluid models in five patient-specific intracranial aneurysms using high-resolution lattice Boltzmann simulation methods. Flow instabilities are quantified by computing power spectral density, proper orthogonal decomposition, and fluctuating kinetic energy of velocity fluctuations. Our simulations reveal substantial flow instabilities in two of the ruptured aneurysms, where the pulsatile inflow through the neck leads to hydrodynamic instability, particularly around the rupture position, throughout the entire cardiac cycle. In other monitoring points, the flow instability is primarily observed during the deceleration phase; typically, the fluctuations begin just after peak systole, gradually decay, and the flow returns to its original, laminar pulsatile state during diastole. Additionally, we assess the rheological impact on flow dynamics. The disparity between Newtonian and non-Newtonian outcomes remains minimal in unruptured aneurysms, with less than a 5% difference in key metrics. However, in ruptured cases, adopting a non-Newtonian model yields a substantial increase in the fluctuations within the aneurysm sac, with up to a 30% higher fluctuating kinetic energy compared to the Newtonian model. The study highlights the importance of using appropriate high-resolution simulations and non-Newtonian models to capture flow fluctuation characteristics that may be critical for assessing aneurysm rupture risk.