The slow-moving Tropical Cyclone Alfred has come to a "near staggering halt" off the coast of Queensland, sparking concerns the delay could make the storm more powerful.