The Queen singer adored being up in front of many thousands of people. Yet his funeral was a small and private affair attended by no more than 40 people