Is drug use a big cause of irrational and impulsive behavior?

One of Many. There are many possible explanations for irrational or impulsive behavior. Substance abuse (including alcohol) is certainly responsible for a great many problematic behaviors. If one has a concern about unexplained irrational or impulsive behavior a consultation with a professional is a good idea.