The heat from the drill might even cause damage that permanently warps the drive. But as long as there are intact sections of hard drive platters, the data stored on those sections is still technically accessible.
Why would you drill a hard drive?
It is a way of destroying it if you have sensitive files.