Should i upgrade to this graphics card? Please read on!?

As long as the video card is compatible with the video slot on the motherboard, the motherboard is unlikely to die just from the presence of the newer board. Upgrading the card may not make a lot of difference though, since the choice of AGP cards is limited and the most performant cards do not use the AGP interface.