It's only intellectually incoherent from the perspective we hold, on the outside of the bureaucracy. From within, either cognitive biases fill the gap, or there is information which, true or not, fills the gap.
I'm not sure which is scarier, as I find myself often wondering whether our governments are barking mad, or know something we do not - or are just deluded by bog standard cognitive dissonance.
Either way, the problem you describe extends far beyond prohibition, and drives much of the world's woes.