I'm a Star Trek fan from its beginning, and I know that one thing they do poorly is time travel. This story is not an exception to the general rule, but today's viewer can be distracted from the flaws by the jarring effect of seeing what writers in 1995 considered fiction.
The "sanctuary" district in San Francisco interns the homeless, the unemployed, and mentally ill people. The government processes them and hands out food stamps. Welfare is not merely accepted, but an enforced one. The writers call the Bell riots a watershed moment of the 21st Century as a harbinger of change for the better. Today we can look at this fiction and see how much closer we are to it now than we were twenty years ago.
I've always admired Arthur C. Clarke for his vision of the future. He was startlingly accurate in his depiction of online media, but we lack only extraterrestrials to drive us forward into his vision. "Past Tense" doesn't require its writers to look so far ahead. They only had to extend a trend line of poverty a few years out. But, while it might have seemed far- fetched in 1995, today's viewer can see that the trend line is no longer fiction.
The only real requirement is that the writers not let the characters get in the way. There is little in the way of character development. Sisko, Bashir, and Dax are observers, even when Sisko has to take part in the action.
Still, I'm not convinced about the writer's view of neckties in 2024...