Drone footage has captured the horrific extent of Alfred’s destructive wake in one regional Queensland city.