I think it can partially work but Local will still need space on the machine to be able to operate. See this comment from Ben for example:
If you have a lot of projects in Local you could also backup and export them to move to your external hard drive for storage and simply remove them from Local when you are done. If you ever need to revisit you could import the zip file back into Local.