As far as I understand a Hefeweizen is put into the bottle with live yeast, which continue the fermentation and create the characteristic thick foam. So indeed, in that case, you cannot have that effect without alcoholic fermentation.

But I am more of a Pilsener guy, and there are a few good alcohol free Pils which I am convinced would taste like the "real deal" with the added taste of alcohol.