Footage shows a roof being whipped off as ex-tropical cyclone Alfred hit Queensland and northern NSW.