Nice idea, shame about reality!
There is virtually no chance of Carlisle being developed for freight. It's in entirely the wrong place. Most freight into the UK (and more arrives than leaves) is heading for consumers. Most of them don't live in the Borders/Lake District (only the fortunate few). The UK's freight hubs will always be south rather than north, east rather than west.