Five hundred tonnes of beetroot is being left to rot due to a collapse in demand, caused by Brexit, a farmer says.