Depends how quickly it sells. It won't have the chance to sell long on the Switch. Sure Switch 2 will probably be BC but BC titles don't sell as well on new consoles as native titles so it'll probably hurt its legs so it needs a strong launch.
Link's Awakening remake sold 6.46m by December 2022, so is probably above 6.51m now and the best selling 2D Zelda. We don't know how much higher than that it is right now, could be over 7m.
I think it has a chance, but I'm not really sure. Maybe it surprises me.