How to add hyperlinks to local files in Numbers?
If numbers app is not expecting a filesystem link, i.e. it is not coded to except such cases, it will not open the file.
Compare this with Sublime's, VSCode's or Xcode hyperlink feature that you can follow by double clicking or command-clicking. They are programmed to do it.