As a representative of the creative profession, I can say that the answer to this question - like a medal - has 2 sides.
1) Artists, musicians, poets and others like them really drink a lot. In art universities, students drink, some from nerves, some for creative inspiration (from the lack of it), some at all sorts of bohemian parties, where not drinking is bad form. Many teachers, freelance artists drink, and, apparently, for the same reasons. That is, creative people merge with the stereotype imposed on them by society. Creative Torment - Recognition or non-recognition - alcohol as a reward or salvation from anguish. Here, it is true, it is not difficult to reach the level of alcoholism and get drunk with any middle manager.
2) But the stereotype, even if it did not arise from scratch, still remains a stereotype. And there are as many hard drinkers or generally inveterate teetotalers among creative people as among representatives of non-creative professions. It's just that drinkers are more noticeable due to their extravagant bohemian lifestyle, so they cast a shadow on all their motley brethren.
In fairness, let's recall similar myths about doctors and loaders, plumbers and conductors, military and watchmen. There is not a lot of creativity there, but alcoholism is on the same level.
The term "creative activity" is incredible vague. Suppose we are sure that a musician and an artist are creative, ahem, professions (by the way, these are not always professions, sometimes just a hobby, what then?). Suppose we are sure that, for example, a loader is not a creative profession at all. But there is, for example, a sound engineer in a recording studio who could do a lot to ensure that the albums of the bands saw the light of day, and in exactly the version in which we are used to hearing them, and although he could not have composed a single note, but he somehow took part in creating the final look, the form of the work of art. In the end, is this a creative profession or not? The question is very ambiguous, and, as it seems to me, does not have a universal answer.
Well, drink more alcohol than anyone? What is a teetotaler? What is a chronic alcoholic? What is the "average for the hospital" (and this is also some kind of incomprehensible value)?
I know a lot of different people involved in this or that creative activity. For some it is a hobby, for some it is a profession or a future profession. And among them there are both non-drinkers and low-drinkers, and people who drink recklessly. I don't think it's worth looking for a link here.
Of course, it is true if there is a fantasy that the level of ability to infuse alcohol depends on the profession. This is what is taught in higher and secondary educational institutions. Before the profession and business, there is only alcohol in the curriculum.
For example, artists drink a lot, along with plumbers, parliamentarians, psychiatrists, janitors, housewives ... These are creative professions!
Now imagine being sober - an artist, a deputy, a psychiatrist, a janitor, a housewife. Don't feel like drinking?