During Sunday’s ceremony, his father Prince Charles and brother Prince William were among those leaving solemn tributes