People are spread too thin with their skills already, so it's no wonder they don't want to learn yet another thing (especially if you aren't the one signing their checks). The databases can be forgiving and EXPLAINs are not easy to interpret correctly for people who don't know databases that well.
A proactive solution of hiring a DBA to build things along with the FE/BE developers will likely never get traction due to costs. Businesses regularly put off performance and optimization until later and they still make good money in spite of that.