We currently use a lot of symbology representations in our map production workflows in ArcMap and are considering moving to ArcGIS Pro, which does not support representations. Many of them will be ok to make the change using attribute-driven symbology, but I am wondering if anyone else has gone through this and has any suggestions about how to deal with representation overrides.
The override is stored as a blob, but we noticed that we can still query for null in the blob field, so I assume I can use this to pull out every feature that does in fact have an override. But then I don't have much information, if any, about what exactly was changed on each representation symbol. Is there a way to get this information out of the blob field, or some other way to extract this information from the database?
Funny, I just imported all of my custom 24-k map products into Pro and am in the very exact situation you are in: very dependent on representation symbology...and I was just exploring how I could get the rotation angel out of the representation override for some of my point layers. Some discussion on that at https://community.esri.com/ideas/10410-graphics-and-free-text-in-arcgis-pro-maps?messageTarget=all&s... which really didn't work for me. We do make edits to the representation symbols as part of our QA process to improve map readability.
Some related ideas https://community.esri.com/ideas/16580-bring-back-arcmap-style-move-and-rotate-tools-for-annotation-..., https://community.esri.com/ideas/8795, https://community.esri.com/ideas/14241-complex-symbology-on-arcgis-online, https://community.esri.com/ideas/16790-arcgis-pro-add-support-for-geometric-overrides, and of course https://community.esri.com/ideas/10410-graphics-and-free-text-in-arcgis-pro-maps
https://pro.arcgis.com/en/pro-app/help/mapping/layer-properties/attribute-driven-symbology.htm might be a solution for you (again, didn't exactly work out in my case).
Holding out for Pro supporting representation, like Arc Map!