Doctors don't make any money from writing a script (beyond the payment for the consultation). In fact, the would make more money if they used counseling rather an a drug.
Doctors then prescribe these new drugs perhaps needlessly (Vioxx?) or over generic ones.
Also in my experience counseling is only affordable to the wealthy or people in the criminal justice system (where it is already too late IMHO).