No. Sequential shifting is one of the Enhanced Shift modes available for AXS systems. With RED eTap, the rider always controls the front derailleur.
Note: SRAM AXS controllers that are paired to 11-speed SRAM Red eTap derailleurs will not be configurable in the AXS app.