In short, she's gone from being a contributing member of an elite crew manning an elite starship to being "the Chief's unemployed wife on a barely functioning space station."

I always sympathized with Keiko over this. She's pretty much in the same situation as the wife of a grad student or an untenured professor, and having grown up in a college town, I ran into a lot of those. It's not a pleasant position to be in.