Transmission is finally going out! What to do now?

I have a 98 Ram 2500 5.9 Gas. As far as I know it has a 46re automatic transmission. Since it is going out I definitely don't want another automatic 😂 this one was bad enough with 2 or 3 gov pressure sensors going out in less than a year.

Now my question is what do I need to get to convert to a manual transmission and does the manual transmission have to come out of another gas? And is it worth switching to a manual??