Well...
Not necessarily. Your AGP port can't be fixed if there's something wrong with it, but I've never seen JUST the AGP port go bad on a motherboard before. Have you tried using any other video card, to see if you can get it to display anything? It might be helpful to borrow an AGP and a PCI video card from somebody, try them both in your computer, and see what happens.
Just throwing stuff out... I'm not sure what steps you took to determine that your AGP slot was bad.
But if the slot IS bad, to be honest, a Voodoo5 might be a bit much for you. I just brought it up because no other PCI video card has that same combination of 3D performance and 2D image quality. But hey, if you're not going to play games, it may not matter what you pick. You could always just go with any old 2MB/4MB SVGA card, with no 3D. You could probably talk somebody into giving you one for free. Or you could get a Voodoo3. That would cost you around $20-25. If you don't play games, don't run in a high resolution (Say, above 1024x768), don't run your desktop in 32 bit color, don't have dual displays... basically if you don't run any really demanding applications video-wise, almost anything is going to be just fine for you. Matrox makes a good video card, but they have a lot of 2D muscle that, again, you may not need.