An agriculture and horticulture show which had been a summertime feature in Cork since the 1960s has been cancelled.