Once a child product is retired, we can either delete the product(if the product does not have an association) or clone the product, this is a by design feature. The only workaround to reactivate such child product is to make changes in the database, If we could reactivate the child product from CRM itself, it would be a great add-on to the functionality of CRM.