Lots of questions - I recommend you visit some Canadian web forums that specialize in the CF. Most notably army.ca - they have a complete area dedicated to the Air Force.
I am a CF pilot - not dead yet, or suffering from PTSD.
We drink just like anyone else - drugs are frowned upon, random drug screening is in effect.
If you CT (cease training) from any phase of your 3-4 years of pilot training, you will be given the opportunity to OT (Occupational Transfer) to another job or you can leave.
Wings are located at Comox, BC -Victoria, BC - Edmonton, AB - Cold Lake, AB- Moose Jaw, SK - Southport, MB - Winnipeg, MB - Trenton, ON - Ottawa, ON - Bagotville, PQ - Greenwood, NS - Halifax, NS - Gander, NFLD and Yellowknife, NWT.