Hi Tej...welcome to the Forum
Yes, in theory, the car should creep forwards.
If it is not, I wonder if the brakes are binding slightly...worth jacking each wheel in turn so it's just of the ground and slowly rotate each wheel ensuring there are no points where it binds. Make sure the transmission is in Neutral when you do this and obviously the handbrake off when checking the rears. Additionally, it is worth checking the Auto Trans fluid to see that it's to the correct level.
Cheers Trevor