But all the deviations from zero that you see, are only numerical artefacts, aren't they?
sols = ParametricNDSolve[{\[Pi]^4 Y[y] -
b^4 N0 (Y^\[Prime]\[Prime])[y] -
2 b^2 \[Pi]^2 (Y^\[Prime]\[Prime])[y] +
b^3 N0 y \[Alpha] (Y^\[Prime]\[Prime])[y] +
b^4 D[Y[y], {y, 4}] == 0,
Y[0] == 0, Y[1] == 0, Y''[0] == 0, Y''[1] == 0},
Y, {y, 0, 1}, {N0, b, \[Alpha]}, AccuracyGoal -> 100]
gives

I suppose that the existence and uniqueness theorem would suggest that there is only one solution, which is the "trivial" solution?
Cheers,
M.
PS: Another clue that the solutions that deviate from zero cannot be accurate is that they do not fulfil one of the boundary conditions, i.e. Y[1]==0.