I don't think Betty was ever in love with Archie but perhaps in love with the idea of being with him because he was the typical jock and she was the perfect girl next door. I totally think that Betty unconsciously wanted to recreate her parents love story. She even said it in the pilot that she FANTASIES them as a power couple. They have chemistry but only as friends tbh. The childhood friends to lovers trope is so overused, keeping them as friends would be a nice change.