I'm going to jump in here so excuse me if I cover points made after Mingc.The study is based on a questionnaire filled out by study subjects in 1982 who were then followed up until 2022. Note that the article was published in 2004, midway through) . This study isn't ongoing but at least one other is. ACS - Cancer Prevention Studies (CPS) Department - https://www.cancer.org/research/population-science/cancer-prevention-and-survivorship-research-team/acs-cancer-prevention-studies.html
The study also references other studies of pipe smokers, so they're out there.
The bottom line is that pipe smoking is bad for you. Your chances of getting cancer or heart disease of some kind is higher than someone who doesn't smoke. It doesn't mean you're certain to get them. It doesn't mean that non-smokers will never get cancer or heart disease. They too are exposed to causal agents other than pipe smoking (stress, pesticides, booze, etc.) just as you are. It just means that you are more likely to get cancer or heart disease because you smoke, compared to someone who doesn't. And the more you smoke and inhale, the higher your chances. But you already knew this. It's not a matter of belief but of probability.
I'm not giving up the pipe. And I'm not giving up driving or fried foods either. But I smoke no more than 3 to 4 bowls a week and sometimes not for months. And I sure am not going bungee jumping.
So, the provided study information was from a report started in 2004 and was not a finished report. Other than the obvious fact that smoking is dangerous, there is nothing I read that can be called conclusive.
Why? Because the report wasn't finished. I also question this report based on the simple fact that the data collected may be skewed because we don't know which data/questionares were used and which were discarded because the information was incomplete or didn't meet the intended goal of the study. In other words, was the data used cherry picked to provide the outcome wanted by those conducting the study?
Having studied and used surveys in the past, I believe a survey can be tailored to provide the results that the person or group who is paying for the survey wants.