That and the Sims Medieval can be added to the drop-down lists of the Sims 2 and Sims 3, respectively.

Is there a way to cheat and assign a secondary aspiration to newly created sims, without ctrl+clicking on their wants until there are enough aspiration points? Googling didn't find any helpful answers

Yeah, if you have SimPE. You go into their character file and check under free time where the secondary aspiration is.

Pick one. Be sure to hit 'commit' before closing the program.

That's the only other way to do it that I am aware of.

You can assign LTA superpowers with my Tombstone mod. I made it so that it can be done on visitors, which can't access the dialog. It is under the Aspiration menu, done on Me. It respects the points you have accumulated. There is another menu to set the aspiration level and points.

I think adult sims directly from CAS are assigned 5 points - at least one of those can be used to give them a secondary aspiration.

Toddlers get 0, child 2, teens 3, YA get 4, and elders 6.
https://sims.fandom.com/wiki/Aspiration_bar (under "Lifetime aspiration")

I would love a re-release of Sims Medieval, my copy got corrupted years ago. Then again, seeing how badly they messed up the Legacy versions it might not be worth it even if it was re-released.

Does anyone have a copy of Realistic Ages: Harder Skill Learning by Lientebollemeis?

Sims Medieval is still available to buy. https://www.ea.com/en/games/the-sims/the-sims-medieval

And even though it doesn't say it, when I bought it the Pirates and Nobles expansion pack was included.