Loveable goofs and misfits struggling against the odds to live up to their ideals are relatable, and that future can actually be aspired to. A future which requires humans to be paragons of virtue that have evolved beyond greed, vice and want, in a universe of infinite free energy and abundance, is unattainable. Neither human nature nor the laws of physics can bend that far.
Also the new Star Trek series are incredibly popular, even among many fans of old Trek, many of whom seem to be able to reconcile it with the franchise's espoused values. I guess it doesn't work for you, but you seem to be in a minority among the fanbase in that regard.