There's a lot of FUD and misinformation driving this, but pilots that have been on the receiving end of abuse from a Karen while doing nothing wrong probably do have some legit concerns about being hassled by some busybody with the app on their phone. Likewise, I suspect the apps will be the "last mile" approach used by law enforcement if they ever do get to try and locate a pilot doing something sketchy, so there's going to be pushback from those who do that, whatever the reason they have.
For legit pilots, I'd assume this will also guarantee that all those delivery drones we keep hearing about will have additional situational awareness from RID and not crash into your drone / let you take evasive actions, which could be a big advantage. It might also lead to a fully integrated airspace if RID receivers are co-located at cell towers or something like that, which will make it a lot easier for enabling BVLOS, higher altitude flights and so on. (Whether any of that will happen of course...)
For most legit flights though, no one will be listening once the novelty wears off (it's quite possibly going to be a phone battery killer), except maybe out of curiousity, and the chances of you getting stopped by law enforcement are probably not much higher than they are at present.
For stalkers, illegal flights around sensitive locations, and so on, it's going to make things a lot more risky though, and that is not a bad thing in my book and worth the minimal inconvenience for the rest of us.