Yes and no, it could be taken that this is just a metaphor, that Angel will become symbolically human in his soul rather than physically human. The other alternative is that Spike who is also a vampire with a soul by the end of season 6 of Buffy is the one who will turn human, the scroll never actually referring to Angel by name