At worst it's a lateral move, imo. From the standpoint of where it can lead you to, both college coordinator and NFL position coach lead to the avenue of NFL coordinator (not saying O'Keefe will become a pro coordinator).
Hours are probably the same, but with less travel (no recruiting in NFL, but much more practice time). I have no idea about the average compensation at either level, but I think NFL position coach would have to be at least comparable in pay.
It's probably a step up, maybe a small one (if doing it for career advancement), maybe a large one (if doing it to reduce travel and go live in the sun).