I don't think you can enable SNMP on the Standby.
I just tested shutting down the fabric ports towards the Standby controller on 3.2(3o).
Surprisingly there was no fault raised and nothing in the event log other than me shutting these ports down.
I did see that the Standby vanished from the Cluster as Seen By Node screen under Controllers > Node-N though. You can see this via the API:
https://APIC_IP_ADDR/api/node/mo/topology/pod-1/node-1.json?query-target=subtree&target-subtree-class=infraSnNode&query-target-filter=and(eq(infraSnNode.apicMode,"standby"),ne(infraSnNode.cntrlSbstState,"erased"))&query-target=subtree&target-subtree-class=infraSnNode,infraWiNode