That's a great course to play once or twice for the novelty, assuming it's not local, and maybe once or twice a year if it is local. But few if any are likely to buy a season pass for a course like that. A course like that is not going to get much consistent or repeat play (i.e. a regular clientele of players coming out once or twice a week every week), so it won't be much of a money maker.
If the property owners can handle that financially and maintain the course anyway, more power to them. But if they're looking for the course to pay for itself with the business it generates, I can't see it working for very long.
The key to a course being a sustainable business is really having a white-level (or even a red) option that will appeal to a far broader group of players. For every 950+ rated type player (whether tournament or strictly casual), there are probably 10 players that are below the 800-850 level. Those are the ones that the course has to appeal to to be sustainable. That's regardless of the price.