LIMITED PARTNERSHIP AGREEMENT of SUPERHERO ACQUISITION L.P. (A DELAWARE LIMITED PARTNERSHIP) dated as of August 17, 2021