I haven't played Starfield, but I think it's less a matter of it being a bad game and more that it really needed to be great as a game that was supposed to reinvigorate the Xbox Series, but it turned out not to live up to the hype.
It's okay to like it, but clearly it didn't get the job done in terms of selling consoles.