To use Analytics or Marketing Cloud Visitor ID in Work space, you need to capture the same and store it in a traffic or conversion variable (s.prop or s.eVar). Else, you need to use Data warehouse to extract.
You may need to check the implementation. Could be something wrong with the data capture.
You can reach out to the person who manages the implementation within the company, OR ask a supported user to open a ticket with Customer Care. (The first option would be the best, since the person who implemented would know more)
The default Visitor ID dimension is only accessible to the Data Warehouse and Data Feed tool. You will need to implement the visitor Id to be set in a custom variable, if you would like to use this in any other tool (such as Workspace).
If you want to do automation, I would recommend sticking with Data Warehouse. It is able to handle greater breakdowns and has better scheduling capabilities. (I am assuming by automation, you mean inserting the data in a different location)