Even though it got a bit lazy in the later TOS movies, I always loved the “color smear” style warp. It just feels fast.
The later versions lean into the theoretical spacetime distortion physics of warp and look cool in their own right, but they don’t get me hyped the same way.
Perhaps they weren't seeing the long-term demand they were hoping for… as in, even if it was pulling in ok numbers now they didn't see a way to ramp those numbers or even maintain them going forward.
In general, compared to the other new Trek shows I've seen much less buzz around Prodigy on both the web and with real life acquaintances, with it not even being acknowledged in many cases. I have yet to watch it myself not because I hold anything against it personally, but because its trailers didn't grab me and I suspect that's a somewhat common experience among Trek viewers… I think Prodigy may have faired better had it been a much more direct sequel to Voyager (similar tone, feel, etc) and had been marketed as such.
I'm no expert in showbiz though so I might be catastrophically wrong, haha.