I think prescriptive authority for advanced practice nurses is here to stay. I don't think it is mandatory and it would not make sense in many roles. ie educator, manager, even case manager. Prescriptive authority fits well with the provider role or for psych CNS who does psychotherapy with medications.
The CNS role seems the least uniform
of the advanced practice roles across the country. Right now it seems state dependent and at least 16 states do not allow CNS to have prescriptive authority at all. But without prescriptive authority, your job prospects are less. It almost seems discriminatory that I can prescribe in one state and not the one right next to it.
I like prescribing but when I became a CNS prescribing was new. I think there is increased responsibility (compared to RN) in all the advanced practice roles. I think diagnosing and psychotherapy take more skill but right now there are a lot of jobs for prescribers. Prescribing includes diagnosing.
I think CNS will make a comeback. Or maybe the NP will dominate. I have known at least one NP who was a nurse manager. (not prescribing). In some facilities they have eliminated CNS educator roles and instead hire managers with CNS. As health care changes it will be interesting to see how the CNS fares. New advanced practice roles will likely develop. In the meantime, I suggest you get to know what is possible in your state and what role you are interested in.
An re: prescriptive authority. You learn how to prescribe. For example, when I started, a mentor suggested I get to know one medication really well in each class of drugs and branch out from there. This worked for me. I guess in the beginning I second guessed my self a lot but like anything it gets easier with practice. I have at least one CNS friend who finds prescribing boring and is trying to do more therapy...
I suggest you focus more on what you want to do and try not to be too scared by prescribing. you may find a role where you don't do it at all and you may find later on you are glad you have the option. Good luck!!