If you're just using him for an in-game team, you'll do fine. NPCs aren't too tough to deal with despite his ability. If you're considering using him competitively, plenty of other people make it work just fine. Archeops is a glass cannon sorta Pokemon; even if he faints in the end, he won't go down without tearing a few holes into the opponent's team. His speed and attack will allow him to one-shot lots of things, in-game at least, and if you get ahold of U-Turn he can easily switch out of trouble when he needs to. Just make sure you generally keep him away from things with type advantages.