If the college does not admit by major (or by major-based divisions), then it theoretically does not matter, beyond perhaps being more memorable than the 10,000th CS major or 10,000th pre-med biology major, if the essays and academic / extracurricular history are consistent with the less common major.
However, if the college does admit by major (or by major-based divisions), the reason it does so is to manage capacity. Meaning that the popular majors are “full”, so changing into them after enrolling is not automatic. In some cases, a very high GPA and competitive admission process may be required.