Probably not. AI code generation will not allow to use memory efficiently.

Quite the opposite i'd wager. Now that AI can figure everything out we can have the AIs do the performance work. Performance work alot of the times also went against developer experience in terms of languages/patterns and such. AI doesn't need to care about DevEx which might also show a shift towards more memory efficient languages and patterns. Only time will tell though.