It would be good if you could wait until 939 CPU's come down to a decent price and more boards are available.
If you're looking to upgrade now, though, the 939 CPU's and boards are too expensive for what you're getting. The good boards will probably all be Socket 939 by next year, but that doesn't need to affect what you buy now. Socket 754 CPU's aren't just going to instantly disappear.
If you could get a Socket 939 CPU for under $300, things would be different, but the cheapest CPU you can get is $485, and there aren't even any nForce 3 boards available yet.