Seems like a pretty good perdition of our future, really. UBI recipients with no labor of value to offer won't have power to change their government for long.
It's unfortunate that the authoritarian future of Star Trek probably wouldn't lead to paradise. Or at least, that's how our culture's view of the future has changed.
Both fictions are a product of their time. I still wish we had the optimism of Star Trek now.
There should really be no reason that people can't be trained or educated even if most of the skills are utterly useless in the face of automation.
If the negative aspect of the future portrayed in the Expanse are culturally absorbed, then there is a strong possibility that the people dreaming of and building the future could see that as a road sign to help them avoid that future.
E.g. it makes the point that we would need to work out ways to create better habitats in space and to concentrate on making a workable biosphere where enough food can be cultivated and raised (yes, cows in space) to survive.
Misleading road signs about the future may be worse than no signs at all.
If UBI was implemented as in The Expanse (food, shelter, and meds are free), I would expect the population of the earth to plummet. The UBI would allow for more people to pursue learning and educating others. It has been shown that when people feel safe from threat of violence and starvation, and when they are more educated, the desire to breed decreases.
On the flip side, perhaps knowing that you are off the hook for paying for the expense of many children would increase the desire to reproduce?
We have birth rate comparison between "first world" and "third world" countries plus migration experience studies (basically, even one generation after migration from a poor to a rich country, there is a massive drop in birth rate, and after something like 3 generations the birth rate is equal to the rest of the country).
Additionally, there is a noticeable drop in birth rates when a whole country gets richer.
I suspect that summarizing collectivism as authoritarian is like summarizing libertarianism as selfish: they go well together, but you can also get one without the other.
I don't know Star Trek very well, but as a utopia I guess they imagine a form of collectivism that largely preserves individual freedom? Of course most of the show centers on Starfleet, an authoritarian organisation like any military, which doesn't tell much about the whole society.
The 1890s demonstrated what a Libertarian regime would dissolve into, instantly: Absolute rule by the biggest dog. It has happened myriad times in human history, from all kinds of pre-conditions. We were lucky, 130 years ago, that the armed forces still believed in voting. Not sure they still do...
TOS-TNG: Klingons were Soviet-Russian, Romans were Chinese, the Federation was sexist (but much less so in TNG than in TOS) and pretended gay people didn’t even exist.
DS9: Lesbians and trans people exist, but only as exotic outsiders. Bajor feels inspired by Tibeten Buddhism and the final parts of the Northern Ireland Troubles.
VOY: ???
ENT: Nostalgia gone wrong followed by 9/11
DIS/PIC: Oh no Cold War enemies are a threat again / Oh no A.I.