Emergence of anomalous transport in stressed rough fractures