I went to a personal event, so I just took my camera and not my bag. When I got there, I realized the CF card was still in my computer at home. I was in the middle of "shopping central" so I decided to run across the street to the mall and just buy one.
Well, I went to four electronics stores, two department stores and a grocery store. All seven had SD cards, not one had a CF card for me to buy.
I used to hate SD cards, mostly for the handling. Several things changed my mind including the above anecdote.
1) I handled microSD cards. Compared to those, SD cards are positively enormous and easy to handle.
2) UHS - they aren't slow anymore.
3) Cost - they aren't expensive anymore.
So, at this point, I wouldn't mind if CF cards disappeared.