Someone says we are going to the moon, some others that we will go to zero, so... make yourself agree!
Zero will only happen if another cryptocurrency completely takes all of the market from Bitcoin because it is technically superior. Since this is unlikely, and because crypto will be a major part of society in the not so distant future, the price of Bitcoin should go to what most people here would refer to as "the moon".
I dont think even then. zero could happen if there would be some technical flaw, that would make btc totally unusable. But for most people that BTC is 1 USD is same as zero.