You have 2 distinct problems here. One is the low engine power and the other switching from sport / comfort.

Fix the MAF problem first, it will affect shift speeds because the trans computer is expecting the engine to be working properly. Be sure the intake piping between the MAF and throttle body is intact, a opening here will cause MAF to read low.

If the trans is having a problem it will either stay in 2nd gear ( limp ) or the last gear selected ( until the key is cycled ) but you will have good engine power.