There’s a YouTube channel called „Tutor4u“ that helped me a lot and of course the great USA Enterprise Tutorial by @scifieric
Unfortunately those are both Blender 2.79 or lower but with a little bit of Googling they can still teach you a lot. Maybe even more so, since you’ll have to find the new place for some commands.
As for the current version. There’s allways the Donut on Blender Gurus Channel.
I look at this and then a I look at what Discovery gave us last season. And obviously it's not impossible, to design a ship, that looks different while still keeping some lineage to what came before ...
Ahh ... that tutorial was so much fun! ... my main problem was, that it’s for Blender 2.7 something, which is pretty different from 2.8 onwards ... but I feel like this helped a lot with learning the new program since you couldn’t just copy everything.