I don't think it's motivated pessimism so much as a shifting tastes and changes in media. There are tons of SF stories with starships in movies, games and streaming platforms. It just happens to be the case that fantasy is more popular then SF at the moment where books are concerned.