No offense but you clearly are not a spreadsheet power user (and to be clear you're starting off with what feels like a pretentious reply/generalization: always turns out that the person stating that opinion is an Excel expert and barely looked at anything else.) I have never heard anyone that has used both products deeply ever admit that Numbers comes close to the capabilities of Excel (and this includes a few former Numbers devs). They really aren't even in the same product category. For basic spreadsheet stuff that 90% of people do, sure, and Numbers does have some UI niceties - but the differences go well beyond drag and drop behavior. It's way harder if not impossible to use AppleScript like you can VBA. What is the Numbers equivalent of ODBC? How do you connect pivot tables to external sources? Excel has tremendously more builtin functions. Excel has far better performance, which can start to matter.
Meanwhile Numbers can have field types like star ratings. It uses a fundamentally different visual abstraction. Numbers focuses more on appearance and makes better looking graphs easily out of the box. At the limits of their feature sets though, these are really tools aimed at different audiences. For basic spreadsheet functionality, all of the major spreadsheet programs in the last 2 decades are serviceable.