“MotherFreakingHood! (Maternal Discretion Advised),” currently finishing its run at the New York Musical Festival at the Peter Jay Sharp Theater, celebrates “the mother you never thought you should be.” Apparently a riff on the sacred status of motherhood, the musical joins the ranks of movies that try to extol the virtues of the role by suggesting what it ought not…