I think this is probably the core of most of these disagreements. If you approach taxation with the assumption that it's mostly just money going to waste, then yeah, you're not going to be very supportive of taxation, especially high tax rates for high income, high net-worth people.
But even if you come at it from that point of view, it has to be acknowledged that there are certain kinds of services which are almost impossible to deliver other than via the government. The private sector will not give you healthcare for all, or any meaningful mass transit (much less HSR), or properly maintained roads and bridges, or a military, or any of a thousand other things that your multiple levels of government spend money on. Yes there is some waste due to corruption or bad decisions, but for most people that is an accepted cost to getting the services that can't be had any other way.
It's fairly easy to devise a system where taxation is fair (or at least more fair), e.g. by having "pots" - e.g. tax sugar drinks, but that tax revenue goes into the healthcare pot and can be used only for that purpose. If the ostensible reason for taxing rich people is "more equality", then that money should go into the "helping poor people" pot and be used only for that purpose (scholarships, financial aid / basic income, etc.).
Obviously, there's a reason politicians don't want to do that... because that would mean they no longer have control over money and can't spend/waste it as they want.
The other issue with the pots system is that it can give people a false sense of entitlement about things which benefit them. For example, consider the commonly-held belief that gas taxes pay for all road and highway infrastructure, and that roads and bridges wouldn't be falling apart if the government would stop "raiding" the gas tax pot to pay for other things. This is trivially googleable as untrue, but the pervasiveness of this belief blinds motorists to the reality of how much their preferred mode of transport is subsidized.
So people in this mindset approach a discussion about something like subsidized train fare and it's hard for them understand why it's a good deal for society.
I'm mainly saying that it would be easier for people to accept new taxes if that was the implmementation (and specifically taxes like wealth tax that are ostensibly "to decrease inequality" and not "because we hate the rich").
But if you actually look at the rhetoric around it, the right wing party that's in opposition slams it as being a "cash grab" and a "tax on everything" that makes life more unaffordable for everyday Canadians. Literally one of the main planks of their platform this election is scrapping a revenue-neutral tax in order to help Canadian families "get ahead".
So was there any value in going to the trouble of doing the rebate? AFAICT claiming the tax was revenue neutral mostly just opened up the gov't to a ridiculous semantic argument about whether it was truly revenue neutral given that sales tax was being applied after the carbon tax. Maybe it would have been easier to just impose the tax and then pair it with an income tax cut or some kind of investment in existing social safety net programmes?
This is especially true because the social bonds and exchange of values and information that happen between someone who is successful and their family is more likely to be successful than the average person. In other words, while it might seem like nepotism from an outward perspective, it could be merit in actuality.
Instead, I'd support very high luxury taxes. Tax heavily lavish private jets, yachts, and mansions. These are the types of goods that will rapidly drain the funds of a rich trust fund kid who offers little to society. Don't take their startup investment.