I know that the first in line is the "Heir Apparent", but is there an official term for the second?
Depends on what country you're taking about. In the UK, the second in line is known as the Duke of Cambridge, but only since 2011 or so.