Aero will win out over weight in most riding situations, but an aero frame is a marginal improvement: position, clothing, helmet, wheels, are all ahead of the frame as far as effect. Comparing like for like when I was looking at new bikes, the new Emonda is 60 seconds an hour faster than the old one, and safe to say about half of that comes from the wheels and bar, not the frame.
NorCal cycling did a test of the SL7 vs the SL6 and the difference was 7% on what I recall being a crit course, cut in half when they put aero wheels on the SL6. They also compared between the SL7 and a BH ultralight with aero wheels on a 20 minute course with elevation and the difference was like 17 seconds. Whether itās worth it to you is personal, but I canāt justify selling my non aero Emonda and dropping an extra 5k to save a minute an hour (less with my 50mm wheels).
This is not me telling you how to spend your money, but if youāre after pure speed thereās a lot of boxes I would personally check before spending big bucks on a top end aero bike. Iām also not in a position to spend that kind of money, so this may be more my wallet talking, my heart still wants a new bike as irresponsible as the purchase would be