I believe that the Rockets could use Zion in the future more than the Pelicans have/will.
Pelicans: This team is dysfunctional. Even when somewhat healthy they suck. Zion and/or Ingram need to be traded. I believe that the first to be traded will be Zion, because his value is slightly lower than Ingram's at the moment.
Rockets: Bring in a star. That's the whole idea of any major trade involving them. Zion is just one of the players they could go for. While not the best fit in Houston, with him not being very "Available" for PT in a city like that. Having other players to depend on is what I believe he needs to actually succeed in the NBA.
PS: I only make this as an idea and shouldn't be taken seriously.