That depends on the area of Civil you will practice in and there are many. If you get into analysis, design, plans and specs yes to knowing how to sketch well. There are some 20 and 21st century areas of Civil that to sketch is generally not needed but not the case for traditional Civil Engineering.
In my career I practiced Civil Eng. in Fla in from 1970 to 2009 as: Surveyor, Research Engineer, Design Engineer, Proj Manager, Dept Head and private consultant. Worked on many projects in areas of: hydraulics, fluid mechanics, water resources, watershed analysis, land development, pump stations, piping systems, major large diameter high pressure pipelines, structural design, groundwater flow, environmental, economic analysis, etc. I was lucky to appreciate, learn and progress from: slide rule, IBM main frame computers with Fortran IV programing, hand calculators, desk top computers with Basic programing, advanced Microsoft desktops and programing, spreadsheets, hand drafting and CAD, etc
Regardless of the years and even in the CAD era hand sketching was a major benefit. To me sketching well is the hand speaking language that complements the spoken word of a Civil Eng. It is needed to describe an idea, a plan layout and details, etc. because CAD operators I was in charge of in the office were Jr engineers (not necessarily Civils) that follow instructions on plans and details from a project engineer that needs to instruct them. IMO as I did you will do well to learn the skill to sketch well just like a mathematician needs to know the abstract language of math on paper or the blackboard. So take some courses in freehand drawing and basic hand drafting so you can sketch 2 and 3D ideas etc. and also learn to print legibly a word processor and electric will not always be available ;-)
Civil Engineering is the oldest of the engineering professions dating from about 4000 BC and can be very rewarding but you must love it or forget it as with any profession that will last decades. So pick the area of Civil that interests you the most and go for it.
Good Luck to you