Speaking as a photographer and not a blender expert:
To give the impression of size requires that you have a common object for comparison. For example, a bus, a person, a crane. The lens and lens setting alone will not accomplish this.
In general, a wide-angle lens ( say 16-24mm or so) will magnify items in the foreground and shrink items in the background. It will also look distorted. A 50mm lens will view the scene as your eye does and a long lens (say 100mm +) will compress. So if you are looking at the ship at a 45 degree angle, the wide-angle will make it appear longer, and the telephoto shorter. But without a frame of reference, there will be no indication as to how big it really is.
If you want the entire ship in focus and you are looking down its length, you will need a small aperture ( large f-stop).
