Without getting into a rant, I can only speak from personal experience of how I was raised and how I attempted to raise my children.
My dad raised two sets of children. My sis and I were the first relay my younger brothers followed 8 and 10 years later. My dad was tough. Don't do this don't do that. He would not let us touch a candy cigarette, bubble gum cigar, there was a long list of don'ts. What he and my mom did right was give us a comfortable home life with love and moral conviction that they lived.
I think all those no's were what spurred my determination to try many things I should have left alone once I was out on my own at 17. I am not rolling it on dad, just saying curiosity can be triggered by emotions that are to over the top. The funny thing is when it came to drugs he never said don't, he just stated it was a stupid thing to do. Any number of times, in a pretty unemotional tone, he just reiterated drugs were stupid. I tried a lot of his don'ts but the funny thing was I never had any desire to do drugs. Considering I was a youth of the late 60's and between Vietnam and the college chaos of the times that is pretty amazing. My dad and mom taught us responsibility and accountability. I tried to teach those to my kids. Everything else was low keyed education. I would do it the same if I had to do it again.
I probably would not smoke in the house with my kids if I had it to do over. I smoked cigs back then and I just would not do it. I do not see pipe smoke as being as detrimental. That may be because I remember seeing cigarette smoke hanging in the living room late at night. I do not believe pipe smoke lingers nor is as thick.
Their your kids and it is up to you how to care for them, no judgement here.