You need to specify the level of the column index that you want to drop.

Since the date column you want to drop is in level 1 you need to mention it explicitly.

df2.drop(columns=["July 1, 2024 (est.)"],level=1,axis=1)