I think it's important to see the difference between SRO and SOR. You can't be on the SOR unless you've been cautioned or convicted. You can be on an SRO (Sexual Risk Order) without being cautioned or convicted. It's not a caution or conviction, so it wouldn't be shown on basic or standard DBS checks, but it would probably be disclosed on an enhanced DBS check.

Meanwhile, the police aren't interested in whether you are trying to turn your life around. They are only interested in detecting offences and preventing further offences. I don't need to know what your restrictions are, but it's a matter of complying with them or you will be getting a conviction, which could well be before the investigation starts, and as it's a court order, the court would take a dim view of any breaches. I think many people who read this sub-forum have or have had either a SOPO or an SHPO, so we can understand that side of things, but having to wait two years for an investigation to start.... It must be similar in some ways to having to wait two years to be sentenced, but any initial court appearance will be more than two years away. Try to stay strong, and don't be afraid to turn to this little community if you're struggling and don't have much support out there.