I get tired during prayer too, although for me it extends to all kinds of sedentary mental activities. It’s probably not “normal” as in common, but I don’t think there needs to be anything wrong either.
DISCLAIMER: Catholic Answers has turned over the archive to Catholic-Questions.org and no longer owns, manages, or moderates the forums. For additional apologetics resources please visit www.catholic.com.