Can VTTablets start without sql_mode set to STRICT_TRANS_TABLES?

Yes. This check can be disabled by setting --enforce_strict_trans_tables=false on the VTTablet.