Starting in the middle, John was the son of Michael Bourke, 10th Earl of Clanricarde and succeeded his father as 11th Earl of Clanricarde in 1726, legally changed his family's name to "de Burgh" in 1752. I noticed as I checked the line most of the LNABs are incorrect - I tagged a bunch and there's a couple of gaps but I thought I'd ping this since its a little odd.
The CP has the first Earl of the 1543 creation [Ireland] as Bourke or de Burgh. After the death of the 1st Marquess and the reversion to the 6th Earl, the surname is Bourke up to John above, who legally changed his name to de Burgh and finally the 15th Earl/2nd Marquess changed it to de Burgh-Canning, who fortunately didn't have any heirs.
I assume the LNAB should be changed to Bourke for the 1st - 11th Earl, and Burgh from 12-15, with a CLN of de Burgh up to the 2nd Marquess. Maybe Earl 1-5 should have the OLN de Burgh? The common errors are either caps De Burgh or a variation of Bourke (e.g. Burke) - thanks!