You can find the trailer below, which refreshes the 2012 MMO original for its new offline packaging. If you're interested and want to pick up the Japanese version, Square Enix has a website dedicated to pre-orders. In classic Square Enix fashion there's some extras to be had, as well as the opportunity to pick up the PC, PS4, PS5, and Switch editions of the game.
As for details, it's still being billed as a single-player RPG, which kind of goes with the territory of the offline pivot. Dragon Quest X offline will arrive on September 15, 2022 in Japan, but there's also going to be an "ultra large expansion" coming in spring of 2023. The standard edition will run you roughly $60 US, while the special edition is about $115 US, and includes the expansion, physical pins, a slime mug, and a spoon for said mug. The list of in-game items can be found here.
You can also go for the digital deluxe edition that nets you the core game and the expansion for about $95 US. Options! Well, for folks who want to pick up the Japanese edition of the game, at least.