This method of testing is generally known as non-destructive testing and it is very rare that the product is destroyed, but it can happen.
Hydrostatic testing is used to prove that a product is fit for purpose and that it can retain its working pressure without any leaks. Therefore the worst case is generally that we will see a leak path, rather than the product being completely destroyed.