Well, in PA anyway, very little money goes to the police department with the tickets they issue. Funding for the police comes, primarily, from other sources - ie taxes.
Citations fall into many different categories that range from local ordinance violations to federal statute violations. When a citation is issued, there is the "Fine" and other "charges". The department does not get a whole lot of money from the fine as that money goes into collective pool at various levels of govt. This money is distributed to departments across each state of the union based on need. In other words, it supplements tax level funding of each department.
The charges, however, cover filing fees, ambulance fees, etc. A town can make more money enforcing local ordinances as they can control the fine and charges.
When I worked on a citation processing module in PA, the citations were reported to an organization called AOPC (association of police chiefs). They tracked each citation issued for reporting and accounting purposes. The process is supposed to be bi-directional with the disposition of each citation sent back to the departments records management system. No money changes hands here.
The actual citation and any monies collected locally are sent to the state...well, assuming they are not corrupt...for processing. This is one reason why Podunk little towns have so many ordinances as they can collect more on each citation. They have little control over state and federal citations, however.
I won't dispute that officers may be instructed to be on the lookout for certain types of violations -however, legally, "quotas" are not permitted. They are used to raise awareness - such as getting the message like to slow down, don't pass a school bus with flashing red lights, or to stop for people in crosswalks.
Other states might operate slightly differently in how citations are issued. The fact that the automated vehicles will reduce a small revenue stream may remain. But, I think any opportunity for an officer NOT to approach a car with a potentially dangerous occupant is something most officers would embrace. Their departments will still be funded by need and to combat the types of crimes prevalent in their community from taxes.
Finally, it is usually to your benefit to go to court - most officers would rather write you up on a lesser charge than screw you on insurance points.. They would rather you learn from your mistake (unless you put someone in immediate danger). So, be polite if pulled over and take it to court if you can afford the time. They know going to court is an inconvenience to you. Them? No so much. So, you get the message.