Some of the confusion about centripital, centrifugal, and reactive forces is just vocabulary. It can be easier to understand if we consider a similar example without rotation.
Suppose you are floating in space near a rocket. A rock is tied to the rocket with a thread. When the engine starts, the rocket pulls on the thread and exerts a force on the rock. The rock accelerates.
$T = m_{rock} * a_{rock}$
The reaction force is the equal and opposite force the rock exerts on the rocket. The rock pulls on the thread and reduces the acceleration of the rocket.
$F = F_{rocket} - T$
The reaction force doesn't cancel anything. It is just a force that added to all the other forces on the rocket.
Since you are floating near the rocket, you see the rocket move. The pilot seated in the rocket finds it more convenient to adopt point of view where the rocket stays at rest. At time $t_0$, the seat is right under him. At time $t_1$, the seat is still right under him.
For the pilot to use laws like $F = ma$, he must redefine acceleration so that $a = 0$. This means he must redefine force so that $F = 0$.
The changes in definition are not big. Everything is consistent if he adds a fictitious acceleration $a_{fict}$ to all accelerations, where $a_{fict} = -a_{rock}$. He adds a fictitious force $f_{fict} = ma_{fict}$ to all forces.
He is saying "$f_{fict}$ acts on everything in the universe, causing everything to accelerate backword with acceleration $a_{fict}$. The total acceleration of rocket+rock is $0$ because of the additional force $F$ from the engine.
Fictitious forces do not cancel anything. They just change your point of view, or frame of reference.
Returning to circular motion, suppose you are floating near a rocket that is stationary but spinning. A rock is tied to the rocket, and rotates around the rocket.
The rocket engine provides the centripetal force that keeps the rock moving in a circle.
The reaction force holds the rocket stationary.
Centrifugal force is useful to an ant on the rock. The ant finds it useful to adopt a frame of reference where the rock is stationary. This is a more complex case, because $a_{centrifugal}$ depends on position.