fix proc_join, check tier explicitly

Summary

Check for tier in _pico_tier explicitly in build_instance function, not in choose_replicaset_id which isn't always called from build_instance.

---

• Close #589 (closed)
• Target branch: master
• Changes should be cherry-picked to 24.2: yes
• Docs follow-up: not necessary