It seems shitty on paper, but if you think about it, it's actually pretty good. Assuming they will now draft Lonzo Ball, this would actually mesh pretty well. Lonzo is a playmaker, and Lopez is a dominant post scorer, so he can constantly facilitate to him, and Lopez would do his thing. Mozgov didn't really do anything significant there, and was a waste of cap space, so this isn't a bad trade at all for the direction they're headed in.
I think they're still in the discussion even though LA is his main destination. If he does go to Cleveland, then they'll definitely be able to run the floor with Golden State, and compete at a really high level (that is if they add more depth to their bench as well). If he goes to LA, then that will be very good for Lonzo considering he'll have PG24, and Brook Lopez to help mentor him, and that offense will be fast paced in my opinion.