If you delete a product it won't be able to be chosen again. Any old or active opportunity that contains the deleted product will keep it.