No. Sequential shifting is one of the Enhanced Shift modes available for AXS systems. With 11-speed RED eTap, the rider always manually 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.