How far could a navy automate without financial or technological limitations?
Short answer
As far as it considered viable.
Notes
Without financial or technological limits, a navy would automate as much as it considered viable. Practical judgment would still determine which functions were worth automating.