Really depends on the activity. For any activity where overuse injuries are common, it’s probably a good heuristic.
I consider myself reasonably fit, but I’m not sure any of the activities I do strictly require physical pain. Soreness? Fatigue? Sure. But rarely pain, unless I’ve made a mistake.