How broad is the Civil engineering major??

I have a strong interest in water resource engineering and renewable energy engineering! I know the civil path is very stable and broad, but would I be able to get into those fields in the future?? My civil engineer family says it's possible, but an academic advisor said I should look into other majors.

Chemical E seems a little daunting for me, and I feel like the Environmental E degree title is just too limiting and underpaid. Should I go with my gut and do the civil route or should I listen to my academic advisor??

Edit: Thank you for all of the helpful answers. I tend to overthink a lot, but now Im more confident in the path I'm going to take!