It's tough. I experienced that at a previous job, at a consulting firm, which prized Excel expertise over everything else (eg over data science skills with Python).
I just left, as I knew there was no easy way to argue.
I think you're in a tough spot. Unless you're very senior, and have buy-in from all the higher-ups, it's going to be almost impossible to change the course of the company. Unless you have a specific reason to stay, I'd move on. It'll be a huge battle that you're most likely going to lose, and even if you win, you'll be blamed for all the downsides of the solution you propose. That was my experience.