There's quite a lot you can do in game and there are tons of ships with many different specializations (cargo, salvaging, mining, exploration, fighters, bombers, corvettes). Some need multiple players to crew effectively

PVE - Cargo delivery missions (from small to large size) - Bounty hunting (in space and on planet) - Mining - Salvaging - Cave exploration/rescue - Escaping from prison

PVP - Bounty/pirate hunting

Just search for Star Citizen content on YouTube. You fill find a lot. My favorites are https://www.youtube.com/@CaptainBerks and https://www.youtube.com/@Morphologis