Yes LGA 775 is over. The replacement is i5, which should be out in a few weeks.
While you might re-use your DDR3 in a future build, the board will be a bit out of date soon.
So, wait for i5, or go AMD now. There is nothing wrong with AMD as long as you avoid Nvidia chipsets.