Well, it can be quite like something from no man's sky. In no man's sky there are massive player owned freighters that can act as player home and a base of operations to carry out expeditions, trading, storing mass amount of cargo.
Also, these freighters are followed by played owned frigates- massive battle ships that can be sent on expeditions or help you incase of fights. Also such an arrangement will mean in case of a dogfight, instead of fighting alone against a dozen ships and somehow winning, which feels so unrealistic to me, now, u can send an sos if your freighter is in the star system and a frigate and a squadron of your ships piloted by your crew will come to your aid.
I do not believe that this is impossible. Because this is kinda what happens in the scripted UC vs Crimson Fleet battle.
The UC M-class mothership has a cockpit, so surely we can expect ships of that size to be player controllable so we can fly out freighter instead of that small ship we get to fly