I'm sure there will be more research in this area, now that there is not the threat of jail if people report on their usage.
First of all, what period did they look at, how many they expected to die, and how many of those did die. 1200 people sounds like a lot, but if their model said that 2.5 people should have died but 9 actually did, your results are extreme but the p-value isn't very high.
Further, do we trust the model that they had for how many should have died? They say what they did. But there are a lot of ways to tweak such a model, and p-hacking is naturally going to lead them to tweak it in ways that make the results look more significant.
Next, even if all of this is true, what is cause versus effect. Are people using marijuana to deal with life stress? If so, is the stress the real risk factor here?
There are a lot of things that can go wrong in a study, and most published studies are wrong. Until I see the methodology checked and the result replicated with a high reported p-value, I'm not trusting this study. Not because I don't like the outcome, but because that's simply how unreliable this type of science is.
In all seriousness, I'd love a breakdown, and references for further study (on how to read medical papers, or scientific papers in general)
I haven't read it, but you'll probably want a book like https://www.amazon.com/Design-Studies-Medical-Research/dp/04... or https://www.amazon.com/Study-Design-Statistical-Analysis-Cli...
realistically you need at least a master's degree in a quantitative field to get the time and knowledge required to evaluate studies like this. I see a lot of armchair "scientists" trying to evaluate studies, it's very common to see basic mistakes in evaluating papers.
When you say it "looks quite convincing", are you qualified to judge it on its merits?