An "auto village" might have been a good thought at one point, but Moncton will soon have almost every type of car dealership imaginable (Volvo and Lexus excepted), and most dealerships in the city have either been recently renovated or newly constructed.
I personally was hoping for a new Cineplex with IMAX and a Rec Room/Playdium, but the whole movie exhibition industry is now on life support thanks to the pandemic, and this likely won't happen either.
The $10M that Costco wants for the building is a
huge impediment for redevelopment. I'm sure Irving will want something similar for the Kent store.
I think the only option is to raze that entire section of Wheeler Park and start afresh, likely with some form of mixed use high density residential development.