Well, it depends on how you define adventure - if you don't mind that it's very linear design, then yeah, I'd say there's plenty to see and explore in game. I like the overall vibe of the game and I've enjoyed combat quite a bit (played it on Wii, had no issues with motion tracking). 

If you go into Skyward Sword without expectations that it will have similarities with BotW/TotK, given that it's literal opposite of them (especially since BotW formula completely scraps item gated progression, which is staple of Zelda since the first game), you will probably have quite good time with it.

Skyward Sword does has my favorite Zelda story (way better than BotW) and some of the best Dungeons. Some neat game play surprises like the time stone mechanics. Overall Music is great.

Compared to BotW, this Zelda game has a traditional progression system of Link getting more gadgets and abilities the further you progress. Some are truly wacky. Usually you need those to unlock new areas or defeat certain bosses. (lock and key structure)

Combat is more of a puzzle in a sense. You do have a parry system, but there is no flurry rush (like BotW). Sword movement is by either motion controls or right analog stick, so you swing the sword where you see an opening of attack. (left/right/up/down/diagonally/stab)

Some of the movement can feel awkward due to being designed for motion control (like flying or swimming).

Originally made for the Wii, which did only have 1 analog stick, the game is not designed for traditional right analog stick camera control (in the Switch version you can by pressing an additional button). This is recognizable in some of the world (level) layout that is designed in the player moving forward (corridor like) except some hub areas.

Here they are!

Zelda: https://www.hasbropulse.com/product/the-legend-of-zelda-heroes-of-hyrule-princess-zelda/G45165X00?cgid=new

Link: https://www.hasbropulse.com/product/the-legend-of-zelda-heroes-of-hyrule-link/G45155X00?cgid=new

Ganondorf: https://www.hasbropulse.com/product/the-legend-of-zelda-heroes-of-hyrule-ganondorf/G44915L00?cgid=new

Preorders open at 8pm ET / 5pm PT.

The Yetee had a couple Zelda-themed shirts yesterday. They are still available today, for the next 15 hours.

https://theyetee.com/collections/continue

YouTuber @domodesu0002 recreated Episode I podracing in Tears of the Kingdom

Source: https://www.youtube.com/watch?v=hGgtUUy_86E

The Legend of Zelda: Tears of the Kingdom--Secrets of the Zonai pre-order is currently discounted on Amazon:

Hero's Edition

Standard Edition

Check this out. Nintendo has a couple vinyl options for fans of Zelda music:

The Legend of Zelda: Breath of the Wild (Limited Edition Deluxe X 8LP Boxset)
$194.99

The Legend of Zelda: Breath of the Wild (Limited Edition Deluxe Double Vinyl)
$49.99

I checked Nintendo Today! on a whim this morning and saw this!

We are getting a Zelda 40th Anniversary Direct in four days! Tune in on Sept. 8 at 7am PT for 30 minutes of who-knows-what.

Here we go!

I'm so ready for Zelda news.