The Pilot Station is where you control the ship from. Once you active the Pilot Station, you are in control of the ship, and the view turns from your 1st person view to a 3rd person view from behind the ship.
To exit ship piloting, press TAB and you return to your position in front of the Pilot Station.
You can also pilot the ship from the Airlock Computer; there is no difference between the two methods.