Your old derailleur is a braze-on type, and the thing that says "Superleggero" on it is a braze-on adapter. Most road bikes with braze-on adapters are also capable of having a band clamp FD mounted also, but there are some out there where the reason for the adapter is a non-standard seat tube diameter, so that's the thing to check. The standard sizes are 28.6, 31.8, and 34.9mm.
Shimano has switched to their "long-arm" design for new Sora, the current FD-R3000. The long arm designs expect less cable pull coming in, matched by the current Sora STIs. I don't have a wealth of experience mismatching the new FDs to the old shifters, but as JoeK points out, conceptually you should be able to do it on a double by starting it with the right amount of cable slack. You may find the feel at the shifter to be kind of wonky if you do it this way. It will start out moving with no resistance, then it will hit the point where the FD begins moving and there will be a ton of resistance since the shifter is pulling a lot of cable per hand input and so the mechanical advantage relationship is opposite from how you'd want it, and then the FD will get into the more easy-moving part of its actuation curve.
Shimano often produces something that can be used as legacy support part for a long time in these situations even when the current groups have moved on with their compatibilities. FD-3500, the derailleur I'm about to recommend, played that role at one time for old 9-speed road groups. They currently don't have something like this in production for a 9-speed compact-friendly road FD it appears, but Shimano is very oblique usually about why or whether that's a permanent or temporary situation.
Your easy choices are get a third-party replacement still made new or get a used or new old stock compatible Shimano FD.
- Shimano FD-3500-F would drop in with what you have. The Shimano FD models that end with -F are the braze-on versions, and -B is band clamp, but again you need to measure what you have and look up what you're getting to make sure they actually would go together if you went that route.
- The Microshift R9 in braze-on (FD-R352-F) is a currently produced third party replacement that would also work here. Microshift is okay quality.
Be prepared to need a new cable whichever way you go in case there are differences in length needed.
Don't get a different speed generation FD than the 9 you need.
If you tried using various of the pre-compact 9-speed double FDs (which is most of them), they would mostly work but there may be some surprises out there with the top to bottom cage size or the chain contact points not being what they need to be. Since you have the ability to get something made to play nice with compact, it's better to just do that.