Introduce me to AFCAT

I am an 4th year student pursuing Aerospace Engineering from tier 1 college. During the period of studying my courses, I saliently realised that maybe i am more interested in flying an aircraft rather than making one(R&D stuff). So the prospect of appearing in AFCAT came to me, I never discussed it seriously with anyone in college since all are more inclined towards their regular coding jobs, then came this subreddit filled with you enthusiastic guys.

So here I ask some of my deeper doubts to you as as my mentor, I heard that some of you are even experienced or current pilots. So thats even more helpful if you can suugest something.

I joined my dream college in my dream branch (Aerospace Engineering)in 2021. In my initial years, some courses like dymanics, visous flow theory, mechanics, high speed aerodynamics cooked my interest in theoretical aerospace, but managed to score decent with help of good friends.then in end of 3rd year I went to Kalaikunda Air base as a trip, where I met flying officers; saw them fly jaguars, su-30; did coordinated takeoffs, those guys showed us their hangers and all, and I felt goosebumps seeing this.Now after it, I lowkey want to pursue, but did not knew who can clarify my doubts.

I am aware of fact that even if i decide to appear in this exam, my chances are near 0 that I get flying branch. So tell me, how many flying officer do they avg select each year? Is there a limit to promotions for those who get through afcat? What we do after 14 year of service? Fly Commercial planes? Are the duties same or difficult or easy than other pilots? What are other options I can explore?

Treat me as a beginner. Also Physically I am fit, player of inter IIT multiple times, mentally i am engineer (its enough to describe).