Thing is, Twilight Princess is the only game in the series to sell the numbers that it did. Everything else is usually somewhere between 3-5 million. The only games to exceed that are Phantom Hourglass (barely), Zelda 1, Ocarina of Time, and Twilight Princess. So, given the patterns of I don't think they were expecting those huge numbers from Skyward Sword, which was released when the Wii was all but dead and they were moving on to the Wii U.
Hardware Comparison Threads:
Current Thread
Is Hardware Getting TOO Powerful?
Older Threads:
PlayStation/Xbox/Switch: 2022 Edition
PlayStation/Xbox/Switch Hardware Battle: 2021 Edition!
PlayStation 4/Xbox One/Nintendo Switch: 2019 vs. 2020
PlayStation 4/Xbox One/Nintendo Switch: 2018 vs. 2019
PlayStation 4/Xbox One/Nintendo Switch: 2017 vs. 2018
PlayStation 4: 2015 vs. 2016 vs. 2017