The hugely popular Pierce Molony, owner and manager of Thurles racecourse, has died following a long illness.