It is impossible to have no transactions, bitcoin is already using globally. Yeah we stored coins but there is no effect like killing it, BTC is circulated through buy and sell, trading and investments. So there is no reason to say that bitcoin is useless.
I think you are correct that we are past the point of zero transactions. There is a whole industry of trading, gambling, and even porn sites that rely on Bitcoin. If we can get the mainstream population to fully accept Bitcoin, it should be successful.