I have a 2023 Sport. My transmission also failed but instead with 25 miles on my vehicle. This happened in less of 12 hours of owning it. They did tell me a code appeared and it was a P0741 code - Torque Converter Clutch Circuit Performance or Stuck Off.
For reference the car still drove fine...