Unless you are Jerry Seinfeld or Jay Leno collecting supercars then whatever vehicle you purchase is a financial liability. Some cars depreciate more slowly than others but they all lose value. Even middle-of-the road family cars can cost more in monthly payments than a mortgage. You can estimate that a car will be worth a particular amount in 3, 5, 10 years time but you are taking a gamble as it may go out of fashion, turn out to be a lemon, get dinged and scratched, etc. There's never a guarantee that it will hold value.
From an overall environmental point of view the best ways to travel from least to most polluting are: walking, cycling, public/shared transit, used EV, used ICE, new EV, new ICE. If you look just at local emissions then both 2nd hand and new ICE are by far the worst as they produce exhaust fumes that can have particularly harmful effects on children. Some people here may remember the bad smog problem Dublin had in the 1980s and Prof. Luke Clancy's campaign to prevent literally hundreds of deaths a year. I'm sure it's not controversial to try to reduce respiratory disease in babies. EVs have a role to play in this.
EVs do have an upfront carbon cost of production but after a couple of years that disappears and over their lifetime they are far less polluting than an ICE. Another big difference is that electricity is becoming more sustainable each year while fossil fuels are about as "clean" as they can ever be. There is also a lot to be said for getting our energy from a windfarm off Wicklow instead of from the maniac members of OPEC.
People greatly overestimate car range needs. 70% of daily car trips are shorter than 10km. Average commutes vary from 7km in Dublin to 17km nationally. Even the highest county average (Laois and Roscommon) is only 27km. That means an overnight charge at home once a week.
A VW Passat will suit most households but it would not suit a large family. If we were to follow the anti-EV thought process we would all drive mini-buses on the off chance that we needed to give a lift to a rugby 7s team going from Belfast to Ballybunion in such a hurry that we cannot stop for a toilet break.