Pen testing is a broad field, you can have some jobs where you will be trying to hack into very important applications or networks and your work will have a huge impact. Or you can have other jobs where you are just running a few vulnerability scans and writing a report based on that. The same as any other field really.

I wouldn't worry to much about not being able to code in order to be a pen tester, an advance level of coding really isn't necessary.

I would ask why do you want to change your job? Are you unhappy with your current job? It sounds like you enjoy it. Keep this in mind because starting from the bottom as a pen tester will be very difficult if you are coming from a high-level role that you enjoy in another industry - you will have to realllly want to become a pen tester in order to start over from the bottom and work your way up. I say this from experience too as someone who spent about a year as a pen tester but decided to go back to my old career because it was not worth spending years to get to the same level I was already at.