My fiance has intestinal cancer and now I wonder what I am getting into. Will this affect his ability to work?

Short term yes. This is a major challenge and he will need all the support you can give him. I agree with dr. Gordon in that a more detailed answer for your situation would require more specific information. Please stay in contact, and good luck to you both.