No, you haven’t got this right, SKenny. I read what you wrote, and it’s not correct.
As Dork32 has pointed out, you generate more wealth when you have more OA dollars earning 2.5% and running 50 basis points ahead of a 2.0% mortgage. You want that deal to run as long as possible, because it’s a money machine, a wealth creator. So no, you don’t want to take a shorter term loan in these circumstances, even if you think you would have problems making loan payments while you’re retired.(*) You can always accelerate repayment of a longer term mortgage, but it’s either impossible or darn near impossible to lengthen a shorter term loan. (What happens if interest rates fall? Oh boy will you be happy that you have the longer term loan.)
Cheap loans should be as long as the lender will grant, assuming merely that you’re a responsible borrower (not borrowing too much principal) and saver. Your retirement date and situation doesn’t actually matter for these purposes.
There’s also the remote possibility of some huge national crisis that is (oddly) personally beneficial. During the Global Financial Crisis there were many U.S. borrowers who simply walked away from their mortgages and their houses. And that was the smart thing to do financially. True, they wrecked their credit scores for 7 years, but property valuations collapsed, and these particular borrowers owed far more than their properties were worth. In the U.S. there’s no full recourse. The banks can take the houses (and did), and you get a bad credit score for 7 years, but that’s as far as it goes. So the smart play for the borrowers was to walk away, and the sooner the better, and preferably with the longest term mortgages possible. Those that did the best were the ones that had paid as little as possible back to the mortgage lender.
That’s not so common in Singapore, but that sort of thing could happen if the borrower dies. The bank takes the house, and the borrower’s CPF nominated heirs get more OA dollars than otherwise. Good for the heirs, less good for the bank, but it’s a small/possible benefit to a longer rather than shorter term mortgage.
(*) And you can always sell the home when the time comes.