That sounds like a tough move for kayak fishing, but Carmel/Monterey are a beautiful change of scenery. Aside from rockfish, they sometimes get White Sea Bass, Halibut, Salmon, and Striped Bass up there. A shot at Sturgeon if you make a drive to SF Bay.
This website may be a good start for your fishing transition:
http://www.norcalkayakanglers.com/
Monterey Marty has a nice ring to it...
Good luck on the move.