The future King made an unexpected appearance inside Westminster Abbey, but he might have regretted his decision after struggling to stay awake