Yes, that's normal. With a normal acceleration, it will start out in second gear. If you accelerate hard from a stop, it should shift to first.
From the owner's manual, page 141 of the '03 manual, under "D - Automatic selection mode":
I have two 986 Tiptronics...