Anecdotally, it feels like the move away from 104th St caused the market to fall off in popularity. People may still go to the Downtown Farmers Market, but it feels like less than before and it's never really spoken of as highly as when it was outside on 104th. To be even more cryptic, I think there was a magic to being on 104th that made the market feel special and unique and worth checking out, which made it more desirable, which meant it didn't have a lack of tenants because it was busy.
I'm not sure what about 97th is so bad. Maybe it's just that it doesn't feel all that special, because if you want an indoor year-round market, Old Strathcona is busier, better situated, and more entrenched to fill that gap. It's not big like the St Albert one nor is it small and neighbourhood-focused like the 124 Grand Market. But when it was outside, on 104th, it was in the middle of a very walkable street with historic warehouses all around you and cute cafes and restaurants. It was also closer, both physically and psychologically, to where people with farmers market money are. Mind you, this never stopped Moth Cafe in the Quarters. In reality, it's probably a multitude of factors, and honestly covid is probably one of the biggest.