In terms of how prepared atproto users are to use adversarial migration, I did a point-in-time survey a couple months ago: https://rob.leaflet.pub/3m7isflo7ls23
I suspect the situation has slightly improved since then, as some or all of the migration tools offer to set up rotation keys for you, but I haven't had time time to do a followup.