A high end audio card should have a much lower noise floor and be able to handle hotter input signals than a cheap one. If you don't care about those things, though, then I suppose a cheap sound card is fine.

Remember that the outputs of a phonograph turntable are not line-level. You'll need a phono-to-line-level converter, or have to run it through a receiver with monitor outs and a phono input.