Relying to heavily on your magic phase can be quite bad, because as mentioned it is a very unreliable phase. One bad role can end it all for you.
Firstly I would question why are you relying to heavily on magic, how many PD are we talking here? Ideally I think a
VC army should have no more than 10 really, using the other points to bump up units, try and be a bit better in the combat phase. If you do this your actual army can do damage as well as the spells.
Secondly, yes the Lore of Vampires generally does work better for us, it was designed for us in the first place

Priority should really go to making sure your units are sufficiently healed and combat capable. Remember that if a unit is entirely wiped out, no more raising it back. So you need to look at what the unit could be facing , whether it be concentrated fire power from archers etc, or are they going to be charged / flanked etc. Try and make sure your units, especially the ones with characters in, stay at least 15 strong for RnF.
Secondly don’t forget that VHD is most probably one of the best spells in the game. You should be using it to your advantage. You can potentially do more damage with a well placed flank attack than from casting CoY or WoU. I personally would save those spells for when IoN or VHD is not needed / feasible.
In regards to using other lores – yes they can be used, and they can be used well. Firstly make sure you take a lore that suits the situation and army you are facing, Taking the Lore of Metal against an army made of predominantly low armoured RnF is of course a waste. Secondly you will still have access to IoN, and I would make sure that has the priority. Finally, again as I said above, using different lores with a more combat orientated force can be more effective, as with more troops hopefully you can absorb more damage before healing, and thus can use your PD more offensively.
I would however in an army that is taking their main lord with a different lore, make sure I have a vamp with the Book of Arkhan, or a
Necro with VHD. As mentioned that spell can win a game if used at a critical point.