My knowledge of Aberdeen isn't great and i'd definitely say that in terms of location, it isn't ideal. I'd rather be able to walk all the way (within reason) from the train station. I guess the main issue is scotlands lack of infrastructure as if there was a railway station nearby, it would be a perfectly acceptable location to all. The club do need to work on their transportation plan but given it is located to big roads, should be seen as a massive benefit. Something can be worked out and it may take bus services to commit but theres a solution there.
However, it is now getting to the point where we need new facilities, redeveloping Pittodrie isn't a viable option as much as I'm sure we'd all prefer it to be. This project is bigger than the stadium and I think folk need to keep that in mind. To provide everything that the club want to provide in the stadium alone would have a serious impact on the footprint. Then there's all the outdoor training facilities, we really can't afford to have a delay in the delivery of these, it's thoroughly embarrassing and a necessity for the future of our club.
I can't recall but I'm guessing the Links site was ruled out for cost of purchase and loss of public land? I'd imagine Kingsford has been chosen due to these factors.
Edit: Slim just said it.