It depends on the student and the school. I would never make a blanket rule that students should only attend schools where they are direct admit to their major. But parents and students should go into it with their eyes wide open, understanding the risks involved and if it is a risk for the student, having a fall back plan if the student doesn’t get accepted to their major of choice.
My D turned down lots of direct admit acceptances for one where she had to apply to her major and it requires a high GPA and test scores to get in. We had no concerns based on her being a top student at this school.