I would look at it in terms of $ per hour. Compared to something like a pro sports game or a concert featuring a big name, it is cheaper. Proably more similar to a day at a large theme park.
Figure $100 per person for an 8 hour ski day. I have no idea what rentals are nowadays.
For your area, you probably have a lot of driving so that is an issue.
So pricey, yes. But comperable to a lot of other things people do.
I'm lucky that I have a decent hill near me, plus I run a school group and also have a group discount club I run. So I get to ski free most years.
I just need snow