I have no experience with Superset. Can you elaborate on a few points where you see it excel beyond Tableau?
https://www.tableau.com/products/server
If you have money, dedicated team of data analytics who are already familiar with Tableau - no need to torture them with other tools.
Superset is lightweight and open source, but only has 5% of the features. So it really depends what you need!