Despite being friends with David and Victoria for over 30 years, Sir Elton has shown unwavering support for his godson Brooklyn and his wife