You said it yourself; people change managers, not jobs.

So you’ve established that continuing to work for this manager is undesirable on multiple levels. Does that other manager want you to come and work for them? Would you want to? Line something up either inside our outside the company so that you no longer have to work for that manager; I suspect your current manager will be gone within a year if another manager was already talking to you about your file.