What are the pros and cons of CWO Flight School or Green to Gold?

You'll need a 110 GT to start for both of them, as well as being a US citizen and having a secret clearance.

If you want info about G2G go to your post education center and sit in their G2G brief with a G2G recruiter. There are several G2G programs and you'll just get confused trying to read about it before you get a brief.

If you want to fly, go to your local Special Operations Recruiting Battalion where you'll also find the Warrant Officer recruiter who will give you a brief about becoming a Warrant officer

FYI you will incur an 8-10 year ADSO depending on what you do. As an officer you have two looks at each rank to get promoted. If you fail to meet those promotion gates you will be separated from active duty, possibly missing out on an active duty retirement

If you can qualify, go fly. The WO flight program is excellent.

Warrant = you get to fly which is pretty cool
Officer = you do a lot of PowerPoints and briefings (but with higher pay)

I kid of course but the career paths are very different. My advice would be for you to really explore how you want your future to look. Loosely put, Commissioned Officers are like business execs who deal with reports and planning whereas Warrant Officers are technical experts that tend to be more hands on with whatever it is they specialize in. In this case if you intend to fly for the remainder of your career perhaps Warrant is the way to go.

I was prior enlisted and went the Commissioned Officer route. I will admit I do often miss 'getting my hands dirty' and being involved with Joes and equipment, but I also have seen the value of gaining experience in a executive type role. It certainly has helped me in my civilian role so there is that. Either way I don't think you can go wrong.

Best of luck to you and make the most of the opportunities out there.