I don’t think you can
Chain Spell says a spell that specifies a single target, and chain lightning specifies more than a single target. They don’t seem to work together.
The most reasonable interpretation, assuming you wanted it to work, is just to have two separate chains: the chain lightning one, and the Chain Spell one. Strictly speaking, though both specify that no target can be struck more than once, those are separate rules so someone hit by the original chain could also be hit by the Chain Spell chain, except for the first target. That doesn’t seem altogether unreasonable to me, balance-wise, but it does seem counter to the probable intent. Actually, combining them at all is probably counter to the intent and the actual wording.
Only If Sources Beyond the Player's Handbook Are Used
Omitted from the online sorcerer description is the following from the Player's Handbook:
[The sorcerer's] new spells can be common spells chosen from the sorcerer/wizard spell list (page 192), or they can be unusual spells that the sorcerer has gained some understanding of by study. For example, a sorcerer with a scroll or spellbook detailing an unusual sorcerer/wizard spell (one not on the sorcerer/wizard spell list in this book) could select that spell as one of his new spells for attaining a new level, provided that it is of the right spell level. (54)
Emphasis mine. Using a very hard reading of the rules as written, if the DM determines the sorcerer can gain "some understanding of [the spell cure light wounds [conj] (PH 215-6)] by study" from the scroll and the spell cure light wounds appears on the Sor/Wiz spell list in another source other than the PH, the sorcerer can add it to his spells known.
As the above is largely campaign-dependent, it needn't be a scroll. The DM determines what exactly the sorcerer can study to gain this understanding (e.g. ancient dragon scales possessing the secrets of weird magic, the corpses of magical minions, the drippings of sacred candles).
I am, however, unfamiliar with a published setting or source that adds cure spells specifically and directly to the Sor/Wiz spell list.
However, another source can totally be the DM's campaign notes. Thus, in a campaign that amends the Sor/Wiz spell list, the sorcerer could, upon understanding the spell via study, select that spell as a new spell when he reaches the next level if the spell's on the Sor/Wiz list at the appropriate level.
The DM should look askance at a player who claims his authorship of another source on a cocktail napkin amends his character's spell list, unless the source is accompanied by an appropriate bribe.
Best Answer
My interpretation of the rules as written would be yes, you can swap spells even if the gained spell does not appear in your tradition's spell list, however, you may not be able to cast them.
My conclusion was based on the following:
Definition of repertoire
The CRB defines repertoire for both Sorcerers and Bards as follows:
This is quite broad. The text explicitly states that any spells gained from leveling must be taken from your tradition's spell list, but does not impose any conditions on gaining from other sources. In fact, it explicitly states that your spell slots and repertoire are not linked:
Learn a spell
The description of the Learn a spell action is very explicit:
Given that Arcane Weaving does not reference this action, it explicitly does not apply.
Arcane Weaving
Finally, since the Spell repertoire class feature does not impose any restrictions and we're not using Learn a spell (which does), we fall back to the text of the ritual itself (emphasis mine):
The rule for this ritual specifically calls out any spell with the only restriction being that it can't be higher than the ritual's level. Additionally, the flavor text for the ritual seems to imply that this is a magical transfer of knowledge, which would presumably include any tradition specific knowledge required to cast the spell.
Casting
Now that we've determined that we can learn the spell, can the character cast it? My guess is it depends.
Looking at the Occult spellcasting entry for Bard, we see (emphasis mine):
As for the sorcerer, the Sorcerer spellcasting entry states:
This seems to me like it may be an oversight in how the class features are written. Personally, I'd allow it in my game, but definitely check with your GM first for their interpretation.