Computer Science is amazing to get into and it's great you want to join the field.
I honestly want to reassure you that you do not need mathematics to be a good programmer, but don't get me wrong it's really good if you have a good understanding of mathematics as it makes it easier to understand programming also you can integrate some mathematical concepts into your algorithms if you want.
It's also great that you have such a passion for science in general because from my experience later down your career path you can use your programming knowledge and become part of a field you enjoy but don't necessarily have experience in such as: music, biology, chemistry, graphics, physics and much more. One example is my colleague loves programming but he got pretty bored of building financial systems and websites so he decided to join a scientific study to program certain bacteria and cells to do what you want and he loves it.
Computer Science is much more than programming (although that's my favourite aspect), there is computer architecture/hardware, file management, databases, graphics, sound, so there is quite a variety.
Please trust me when I say you will not be overwhelmed, when I done my undergraduates degree many years ago I was in your situation having no experience in programming at all and not particularly strong in mathematics. Some of the content may be a little challenging but that's part of the fun and you're a smart guy you'll get through it!
Good luck and I very much hope you decide to study Computer Science