The situation you describe is the following : a mass $m$ in rotational motion on the edge of a turntable of radius $R$. The mass has no other forces acting on it, and is held at rest relative to the turning table by static friction $F_{static}$. The assumption of the mass being on the edge is to simplify the analysis (more on this later)
In the "lab" frame, we observe the rotational motion, say at angular velocity $ω$. The fact that a mass $m$ is in rotational motion in a circle of radius $R$ with angular velocity $ω$ implies that there must be an radially inward force acting on the mass of magnitude $mω^2R$. This is a simple geometrical fact. This inward force is called the "centripetal force". The only source of this force is the static friction, hence $F_{static} = mω^2R$. It goes without saying that this is a "real" or "inertial" force.
Now, let us analyze the same situation in the turntable frame. In this frame, there is an inward "inertial force" of $F_{static} = mω^2R$, and the mass is at rest. So, there must be an equal and opposite pseudo force, which we call the "centrifugal force".
As we can see, higher the $\omega$, higher the $F_{static}$ required to hold the mass at rest relative to the turntable. Note that between any two materials, there is a maximum possible $F_{static}$ ; $F_{static} \leqslant \mu_s mg$, where $\mu_s$ is the "static coefficient of friction". If we imagine steadily increasing the angular velocity, the mass will rotate with the turntable up to $\omega \leqslant \sqrt{\frac{\mu_s g}{R}}$.
But now, imagine increasing $\omega$ to $ \sqrt{\frac{\mu_s g}{R}} + \epsilon$, where $\epsilon \to 0^{+}$. The mass will now come unstuck, and will experience $kinetic$ friction $F_{kinetic} = \mu_k mg$. Note that $\mu_k$ is understood to be less than $\mu_s$. In order to continue moving in circular motion with angular velocity $\omega$, the inward force required is $\mu_s mg$, however, only $\mu_k mg$ is available. Hence the mass "flies off". In our case, when the mass is at the edge of the turntable, it flies off tangentially. In case the mass was inside (not at the edge), the analysis is a little more involved; its trajectory will resemble a spiral of increasing radius from the point at which $\omega$ exceeded $\sqrt{\frac{\mu_s g}{R}}$ (spiral, not straight line, because there is still a frictional force acting on the mass) till the spiral hits the edge, at which point, the mass just continues in a straight line, and "flies off".
Note that the only forces that are "real" (with reference to the equivalence class of inertial frames) are the ones measured in an inertial frame. The "fictitious" force is a result of analyzing this motion in an accelerating frame. But this may just be a matter of convention. After all, we can think of an equivalence class of frames rotating with $\omega$ just as well as we can think of an equivalence class of inertial frames. However, I still want to argue that it is more appropriate to say that he mass flies off due to there not being enough centripetal force, rather than to attribute the flying off to the effects of centrifugal force. Let me explain why.
The reason the mass flies off is (superficially) different depending on whether we answer this question in the inertial "lab" frame, or the rotating frame. In the lab frame, there is no longer enough inward (centripetal) force to force the mass around a circle of radius $R$ at angular velocity $\omega$. In the rotating frame, there is no longer enough inward (centripetal) force to keep the mass at rest, given that there is a (outward, centrifugal) fictitious force $\mu_s mg$ also acting.
You may call it a matter of taste or convention, but if I had to sum up the above in a catchy phrase "the mass flies off because of there is no longer enough centripetal force" seems a more apt conclusion from both the above statements (if for no other reason, just the fact that this phrase repeats in the reasons given by both frames for why the mass flies off) than "the mass flies off because of the effects of centrifugal force". I rest my case.