Should I pursue CPL training course or opt for cabin crew course after completing class 12th in science?

Better if you have good looks and communication skills that you go for cabin. If you're good in maths and science,l go for pilot.

Civil aviation industry is growing. If you pursue pilot course, you have prospects during lifetime and after retirement, you can continue to be hired by pvt parties on contract basis. So, if skilled luck follows you, you can go through pilot course.