So OLE DB is going away. Yet you have said nothing about ODBC going away. If I were to set up an ODBC connection to one of my SQL servers OLE DB is just one of the options. If you are not on a flavor of Windows then I hear the OLE DB is the best choice.
As long as ODBC it self is still supported and there is a good driver to use I think that most folks can deal. I have used ODBC drivers for Quick Books, Access (ugh), Clent Access to get at AS?400 data. Fox Pro, SQL, and others.
As long as we have the freedom to get to the data (in a controlled and secure way of course) that is what is needed (IMHSHO). They close one door, we find a window.
Technology changes. Sometimes old ways have run their life course. Celebrate the good times and the life accomplishments with a large glass. Sing some songs and move along. You will be raising one over me soon enough.