Tropical Cyclone Alfred’s impact is expected to be felt from today as the system’s “destructive core” bears down on Queensland’s coast.