One of the biggest Star Trek names that blew my mind when I first read about it was ...

Lieutenant Commander Paul Stamets, Astromycologist and Engineer

Named after the real life Paul Edward Stamets, an American mycologist and pioneer in mycology research and science

https://en.wikipedia.org/wiki/Paul_Stamets

I know most Trek fans already know all this information but when you've been out of the loop with Trek culture and general culture in real life ... it was very surprising for me when I first realized the connection between the real world personality and the on screen Star Trek character. And they did a great job of representing the name and associating them to the work that they do.

And like the real life Stamets and the on screen Stamets, our TenForward Stamets has a habit of working their tendrils of connection deep into this community and making it stronger.

doesn’t fit for discovery

I'm probably far from the first person to make this connection, but Noonien seems like a pretty obvious phonetic misspelling of Nguyen to me. I last watched TOS and a lot of material related to Khan as a kid and I don't know too much about Roddenberry as a person, but given his other stances I think it's not impossible that this is his "hidden" commentary on the Vietnam war. And even putting all of that aside for a moment; his "friend" (if he really existed) might've been ethnically Chinese, but born in a different Southeast Asian country and the native language there then adapted his Chinese name to fit their phonology. But I don't know, I'm not a professional linguist, I might be way off here... (Ah I just saw Deceptichum had pretty much the same thought as me but was faster in writing them down ^^')

It could also be a butchered understanding of their name, ex. Qin as kim, Nguyen as noonien (Whos to say they werent from down sound with Viet family), song as singh. Etc.

Add to that using the wade-giles or mathews or whatever old timey pronunciation/spelling system, the passage of time, and a bit of 1940s racism in not bothering to get foreign sounding names correct and you could easily end up at Kim Noonien Singh.

And Uhura is based on uhuru, meaning 'Freedom'

He just likes curd cheese, what‘s wrong with that?

And not just any old mycologist, but one who's very well known in the psychedelic community.

First time I saw Discovery, saw they had Stamets and a "spore-drive" which utilises a discrete subspace domain, I was hyped. A mushroom with "roots" literally everywhere, and that humans can, at least to some degree, connect to this network? Feels rather familiar to most people who've tried recreational shrooms, I'm sure.

Also, on a sidenote, Ultima Thule is mentioned in Star Trek: Enterprise as a planet I think in the same episode that they use Iittala's Ultima Thule glass-collections as "alien" glassware. (Ultima Thule is an old Latin concept for like a mythical land far North, modern interpretations have included Orkney, Shetland, Northern Scotland, the island of Saaremaa.)

I happened to be drinking from an Ultima Thule collection glass when watching the show. So when this scene came on, I looked roughly like Dicaprio in the beer pointing meme. Only with an Ultima Thule glass, ofc.