The Honda Type R will it be automatic in 2023?

Based on earlier Civic Type R versions, it is most likely that  

the 2023 model will only be offered with a manual transmission.

From 2017 until 2021, the Civic Type R's first generation was built,  

and it was only offered with a six-speed manual transmission. This was due to the Type R's design as a

high-performance driver's car, which made the manual transmission more enjoyable to drive and gave the driver more control.

Honda might eventually offer a manual or dual-clutch transmission

features, such as a 306-horsepower turbocharged engine, a six-speed manual transmission, and front-wheel drive.