This sorta works
In the Awakened Spellbook feature description, it states:
you can temporarily replace its damage type with a type that appears in another spell in your spellbook,
But meteor swarm has two damage types; fire and bludgeoning. As such, in a strict reading of the the feature, it doesn't look like it is built to change both. It is written assuming there is only one damage type per spell, which is true about 99% of the time.
You would have to talk to your DM to see whether they will allow only one damage type to be switched, or both, or neither. As a DM, I would allow the character to switch one, but that's just an opinion.
You have another problem
Awakened Spellbook continues:
The latter spell must be of the same level as the spell slot you expend.
You need to have a second 9th-level spell that causes lightning / thunder damage. It has been suggested that prismatic wall would fit the bill. This would be another DM call as the wall doesn't directly do lightning damage. It has the potential to do so, but only if someone enters the yellow layer, which requires crossing the red and orange layers first. This is similar to chaos bolt, which could do lightning damage, but doesn't necessarily. However a chromatic orb would be fine as the caster can declare the damage type at casting.
Also, prismatic wall is both helping you and hurting you. It has the potential to be a spell that does lightning damage, but it also has the problem of allowing the Destructive Wrath to affect multiple damage types. The wall has five different damage types. What would happen if the caster converted them all to lightning/thunder? That's a lot of max damage.
So in the end, it's really up to your DM whether they'll allow all of this to happen. And if this is for a one-off where you're automatically 19th level (17 wizard/2 cleric) to cast a 9th level spell, then see what happens. But if this is for a build where you're working up to that point, it seems like a lot of work for a one-time payoff.
Alternately, don't be a wizard
If this is a build where you're going to be spending effort to level up to reach this "capstone" of destruction, then don't be a wizard.
Take Sorcerer levels instead, any subclass; they get a metamagic feature called Transmuted spell:
When you cast a spell that deals a type of damage from the following list, you can spend 1 sorcery point to change that damage type to one of the other listed types: acid, cold, fire, lightning, poison, thunder.
This means you can swap any fire damage spell for lightning or thunder, regardless of level and if you have a matching spell.
No, you can't swap out the bludgeoning damage in meteor swarm, but you'll have the same "swap to lightning" effect with any other spell along the way to that point.