Generally (as the Help describes) yes, the Short self test and Extended self tests are usually fail if the drive has any, even minor issue, see:
https://www.hdsentinel.com/help/en/62_testfaq.html
"In some cases, these hardware tests (Disk -> Short self test, Disk -> Extended self test) are not available, not supported or they result in an error quickly even in relatively low number of problems. No further information is returned about the result, for example it is not possible to list the sector(s) which are damaged. In such case, an appropriate software testing method is required."
So yes, it is "normal" and somehow expected that the self test may likely fail. As I see on the Disk Repair page, very-very high number of sectors damaged and while the Disk Repair test could fix most of them, there may be some sectors still not working as should.
This is not surprsing, when the disk drive has very high number of problems (and we fix them) yes, we may expect more and more sectors failing near the original area. This is especially true if the problems form a larger section on a well defined area (eg. the end of the disk surface as you can see).
You may refer to this page:
https://www.hdsentinel.com/help/en/61_surfacetest.html
as the bottom shows some common examples about disk surface maps.
The "Disk Repair" test is best and most effective to repair relatively low number of problems. When the hard disk has lower health and/or very high number of sectors affected, then the best is to use the Disk menu -> Surface test -> Reinitialise Disk Surface test.
This clears all data (so should be used only after backup, which may be possible after the Disk Repair, as it stabilized many sectors). The Reinitialise Disk Surface test may improve the disk status and usability - and then, in many cases the short/extended self test can be completed.
However, I completely understand and agree that (after so high number of problems) you'd not trust the hard disk in a mission critical environment. Anyway if you'd still have the drive (did not trash yet) then you may attempt Disk menu -> Surface test -> Reinitialise Disk Surface test. At least this may give a drive to be used for secondary storage (to store non-critical data).
