Any major is a good major. Psychology, in particular, is a good major if you are interested in learning about people and their behavior. There are many people who can be called a "psychologists" - they can be PsyD, PhD, or social workers skilled at counseling. Depending on what type of psychology you are interested in, and your decision on career shouldn't be dependent on how many people are working in this field, instead, if you can see yourself working as a psychologist.
Majoring in psychology doesn't mean you have to be a psychologist after school. In fact, many people who majored in psychology ended up going into business. You can use your degree and the soft skills you learned from college on your job. And the price tag of the degree depends on the schools you go to. If you decided you don't want to major in psychology but a minor, that is still something because you can still talk about it during your interview or use the knowledge you learned on your everyday job.