With the help from some kind people at #dbix-class I was able to work my error out, I share it for the next poor soul who runs into this.
My error was simply not groking, that when used with Catalyst, the resultset class needs to be located in lib/MyApp/Resultset/Table.pm. Duh! So simple.