I think this will have tremendous impact on the user base. I can actually see a lot of hipsters, artists, etc who on their own time enjoy a puff or two being out down by this policy.
Sadly there is not a way to have the creation of such websites banned yet.
I understand this sentiment and where are you coming from, however removing freedom is rarely, if ever, the answer. It sets a precedent and it can escalate quickly to authoritarian rules playbook... that never works and actually, unless Apple has a sound argument better than “I don’t feel like it”, it should be compelled to be put back.
An angle is to imagine what if it was for your own benefit... not saying that you should, because it’s actually nasty, but objectively speaking IT IS competition freeing itself on its own... people that abuse substances, if all things are equal, are ultimately denigrating their health, denigrating their finances, some of them might even kill themselves drunk to death, to drug overdose, etc.
A good analogy, imagine there’s a race to run, but so much people binge eat their way towards overweight and associated problems (diabetes, heart problems and overall impaired lives) that your race will mostly be between those very few left.
Most people will just recreationally puff by, some will get stuck and jump to other stuff and a very small minority might actually get rich with a side business out of it... besides the richer ones, all the others are clearing the path in one way or another.
Yes, it’s sad if it is a known or close one in a bad spot, but for the vast majority it is all in good fun and good vibes.