It is binding in the sense that it's "the will of the people", albeit by a slender margin, and it's kind of tricky to just ignore that. I personally suspect the Prime Minister is not highly committed to Brexit (she campaigned against it) but can't be seen to be "sabotaging" it by action or inaction, so she's got her game-face on. But she might come back later and say "it just won't work" or "Europe has offered us a better deal on immigration if we remain in", so let's have another referendum.
> a lot of fuss and hot air about things that will possibly not materialize
Or they might materialize, and it could turn out to be a Bad Thing, which is why people are worried about it. The continuation of the current status quo seems highly unlikely, whatever happens.