I’m struggling to get my head around someone who just got into Star Trek starting with Picard.

I mean, fine - if you enjoyed it that’s great! But it’s a show explicitly about exploring the later life of a franchise figurehead. If you didn’t watch any of the earlier series or movies first you’re missing 90%+ of the context for what’s happening, surely?