That doesn’t solve the issue that the passengers will need to live on the ship for a thousand years, even if their relatives will be on Earth for twice as long.

Even a very big ship can be boring after a sufficiently long time.