I certainly wouldn't want to be a cop. The downsides right now seem so much greater than any upside. And you already needed to be doing it for some reason more than just money.
But a lot of the problem is self-inflicted. The bad apples may be few, but instead of making a show of culling those from the force, they celebrate protecting them. We need less militarization, a lot more transparency, an actual separate oversight organization that has the power to police the police. And we need to 'defund the police' only in the sense that we need to quit asking them to be social workers, and actually shift funding to that department so it can be properly staffed.
It's possible, and very desirable, to rebuild trust in our police force. But we do need to agree on that first. It's become yet another front in the ongoing tribal warfare so I don't think anything meaningful will change in the near future.