St. Mary's College president to resign over enrollment woes