Trying to see into the future and know what will be socially acceptable or not is hard to judge. The thing about smoking is that mankind has been smoking since ancient times. The Native Americans began cultivating tobacco in the Andes mountains over 7,000 years ago. 2,000 years ago the ancient Egyptians were smoking pipes, just not tobacco. We tend to think that anti-smoking campaigns and the spread of the health risks of smoking tobacco is a modern phenomenon, but actually tobacco smoking has always had its detractors:
Have you not reason then to bee ashamed, and to forbeare this filthie noveltie, so basely grounded, so foolishly received and so grossely mistaken in the right use thereof? In your abuse thereof sinning against God, harming your selves both in persons and goods, and raking also thereby the markes and notes of vanitie upon you: by the custome thereof making your selves to be wondered at by all forraine civil Nations, and by all strangers that come among you, to be scorned and contemned. A custome lothsome to the eye, hatefull to the Nose, harmefull to the braine, dangerous to the Lungs, and in the blacke stinking fume thereof, neerest resembling the horrible Stigian smoke of the pit that is bottomelesse. — King James I of England, 1604
However, even King James wasn't able to stomp it out and like some many governments since, learned that there was revenue that could be generated taxing this "wicked" leaf.
It's hard to say how people will view pipe smoking in the future. Humanity seems to ebb and flow over the decades and as such the popularity of certain hobbies and habits change with them. With the advent of the cigarette, especially with its rise in popularity after World War I, pipe smoking ceased to be the primary means by which people enjoyed smoking tobacco. Yet, today (FDA aside), we probably enjoy far more blends and varieties of smoking pipes, than our granddads did back in the 1930's thru the 50's.
What will the future hold, perhaps in another 50 years advances in medicine will come up with the magic pill that "cures all cancers" and without such a risk being hung as an albatross around the neck of tobacco smokers, then more folks may more readily partake in the pleasures of pipe smoking without any of the perceived health risks. Or society may evolve to become more "libertarian" and we move away from our current regulatory "nanny state" overreach. Only time will tell. Until then, I will continue to enjoy my pipes and tobacco.