Since the most recent application and new plans came out, the mood amongst the supporters is shifting. If the proposed shuttle services work (buses ever 2-3 mins before and after game), I don't see the locaton being a problem.

The location isn't actually in the middle of nowhere - it's on the edge of the city and only about 10 min drive from city centre, when the traffic is light. There are plans for housing on the same location (no doubt being built be Stewart Milne), which will bring pubs and shops. There is also going to be a large supporters bar located in the stadium (in the large glass corner bit you can see).

I think crowds will go up, initially. The novelty and experience of going somewhere better than our current home will see a lot of interest from lapsed supporters.

As for financing it? This has never been made entirely clear, but I don't believe the plans would be getting pushed through if it couldn't be financed. I think SMG (acting for Aberdeen) plan to build flats on the site of Pittodrie, with sale profits going back to Aberdeen. A few wealthy businessmen may also be making contributions....not sure if Trump is one of those