When you delete a product all the ticket URLs that had the Product URL will become inactive and when your customers try accessing the links it would throw a '404 error'. This would be the case for any links with the URL and not specific to the tickets.
The association of the product with tickets raised will be removed and you will not be able to filter out those tickets separately. Any automation in which the product is a condition will not work as well.