It is not centrifugal force that allows a
non-aerodynamic body not designed to be aerodynamic to achieve lift by harnessing the energy from thrust unless it is going so fast that it is in orbit.
If an object is moving fast enough, it would eventually get to the point where it would be in a low orbit; in that case I suppose you could say it is the centrifugal force keeping it at that height (orbiting), and of course, the lower it is the faster it must move, and the more thrust is required to counter the air resistance.
Typically when we talk about something moving through the air, the thing providing a constant height would be the aerodynamic force acting on it. Even a brick can fly aerodynamically by creating lift from striking air molecules if it has enough thrust to keep its speed high enough to do so.
It is still due to the air's Newtonian action-reaction on the object. Unless of course, we are talking about vertical flight, in which case the lift comes from the Newtonian action-reaction from the thrust, not the air.
I don't mean to exclude thrust vectors here. Of course, the angle of thrust will play a part even when there is Newtonian aerodynamic lift.
If you're talking about orbital properties, check this out in the space section of SE.
So, given enough thrust, can any body fly because of the centrifugal
force created against Earth's gravitational force?
Yes, but it would be called orbiting, not flying.