Should climbing shoes be painful to walk in?

Not really. They maybe uncomfortable and borderline painful, but you shouldn't actually feel any pain.

If you have blisters or you aren't used to climbing shoes, that could change the situation. Until your blisters go away or until you get used to your shoes, you could feel some pain.